11/29/2023 0 Comments Visualize data excelThe area under each product shows the relative contribution of the item in the overall sales. In the above chart, we have shown the contribution of different products in the overall sales from 2014 to 2018. Again, if we take the above example of a super market, we can show the sales evolution of different items over time. It can be used to demonstrate the evolution of different items that contribute a whole. The Area chart is another visually appealing chart used to show the contribution of different activities over a period of time. Hence, the project status can be assessed right away by looking at the spider chart above. The gap between the blue and orange lines on each activity represents the under-achievement in the activity. There is a common vertical axis for each activity where the actual vs planned activity is plotted. The blue line shows the actual completion % against each of the activity and the orange line shows the planned completion. External development, Wooden door frames, marble flooring, etc. In the above chart, we have depicted the different activity in a typical real estate construction project i.e. See below is a graphical representation of one such illustration. One typical use case of a radar chart is to show project activity status report on actual completion vs planned completion. It is also called a spider chart since the visual look of a radar chart is similar to a spider web. It can be used to show both increases and decreases in the total contribution.Ī radar chart is another simple yet powerful chart in Excel which helps to visualize multivariate data on a single chart. Using a waterfall chart is a very effective way to demonstrate the contribution of the different elements of a total. From this, the discounts are reduced to arrive at the net sales of the company. They add up together to be equal to the gross sales. It would look something like below:Īs you can see in the above chart, the vertical columns show the sales contribution of the different items. For example, we can use the waterfall chart to show the sales contribution of different products for a supermarket. Note, the 2 variables are related and can be meaningfully plotted on a combination chart.Ī waterfall chart is used extensively in Excel to demonstrate the evolution/contribution of different items to a variable. In the above chart, we have plotted the absolute Non-Performing Loans of a Bank on the horizontal axis and the % of Non-Performing loans on the vertical axis. A graphical example of a combination chart would look something like below: Generally, we plot a column chart on one of the axis and a line chart on the other. the primary vertical axis and the secondary vertical axis. There are typically 2 vertical axes in this chart i.e. Let us look at some of those interest charts that are already available to use at the click of a button.Īs the name suggests, this chart can be used to show a combination of 2 different variables on the same chart. There are some very powerful charts functionalities inbuilt in Excel, that can be used to depict numbers visually. Microsoft Excel can be a great tool for visualization purposes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |