![]() When you plot all the data on the same axis, you lose the ability to compare data of different scales. ![]() I am sure you can’t tell by looking at the chart.īut if you look at the numbers, the profit soared by 125% in 2019.Īnd that’s the issue with this Excel chart. What if I ask you to tell me how much change happened in profit margin in 2019 (compared with 2018). The blue bars represent the sales value and the red ones (the little bars next to the blue sales bars) represents the profit margin. ![]() Suppose you have the following data set of Sales and Profit margin of a company for six years.īelow is the chart that I have created using this data. Let me try and explain this by using an example. Why Add a Secondary Axis in Excel Charts? Adding the Secondary Axis Manually (Excel 2010).Adding the Secondary Axis Manually (2013 and above versions). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |