![]() ![]() A secondary axis chart does not add a 3 rd axis or dimension to your chart (Z-axis), it is more like a second Y axis.ĭownload SecondaryAxisChart.xlsx to work along with the tutorial. To see both and how they correlate, we’ll need to use a Secondary Axis Chart. ![]() So, if you’d like to see the profit percentage, which is usually a value of 1 or less, plotted with the sales price, typically a much larger value, using a regular chart style will render the profit percentage virtually invisible. Divide this remainder by the production cost, and you get the profit percentage. ![]() When you subtract the production cost from the sales data, you get the gross profit. For example, let’s say you have data representing the sales of products. If you have two data series that are related, but not comparable, it might be tough to chart it. Categories: Charts, Excel® Tags: excel chart secondary axis ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |