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.
By Melissa Esquibel Categories: Charts, Excel® Tags: excel chart secondary axis