In the previous example, we have seen the combination of sales, COGS, and profit margin. In the year 2013, COGS is more and profit comes down drastically. From the year 2013 to 2016, revenue is constant, but profit fluctuated due to variance in COGS.In terms of profit margin, the year 2008 has given a profit percentage of 66.50%, which highest in terms of percentage.It has reached its peak sale in the year 2012, i.e. Sales have fluctuated throughout the last 10 years.Below are some of the important observations of the above chart. Now you must be thinking about what the use of the combination chart is. I have changed according to my preferences, and combo charts looking like this in Excel. You can change the line color and column bar colors according to your wish. Step 11: It will give us the below combination chart. Step 10: In the same window, change the chart type of both COGS & Profit to Line chart as shown in the below image.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |