But percentage values are so small (less than 1) in comparison to the sales that the columns of growth can't be seen. We can see the legend tagged below it is nowhere on the graph.Īctually, it is right there. But something is not right? You can see that sales record on the chart but where is the growth bar. Go to insert tab -> Charts -> Clustered Column Chart. Now, I am required to visualize this record on Excel 2016. Column A contains the name of months, Column B contains sales done in the adjacent month, and Column C contains the growth in comparison to last year's month. Here, I have a sales record of an XYZ company, in an excel sheet. Without any delay, let's start with practical use.Įxample: Create a chart and add secondary axis in excel A secondary axis is required when you have to compare two distinct types of series on the same charts, mostly whole values and percentages. A secondary axis in excel is a marker on the right edge of the chart that measures a different value on the chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |