Creating a Dual axes chart
If we are to compare measures that have the same scale and unit of measurement, then we can use the Blended axes chart. However, what if the measures don't have the same scale and unit of measurements and we still wish to compare them? For example, we may want to compare the revenue earned and the discounts offered. Revenue will be an absolute number whereas discount is going to be a percentage. The scales and the units of these measures are completely different.
In this case, we will use a Dual axes chart, where we have a secondary Y axis, which will contain the other measure that is to be compared. Let us see how we can create a Dual axes chart.
Getting ready
We will continue with the same example we have used for both Individual axes and Blended axes charts, where we are comparing Sales and Profit across different months for all the years. Let us quickly create a Dual axes chart by following the steps mentioned in the following recipe.
How to do it…
We will create...
