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.
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.
As mentioned earlier, we will use a Dual axes chart while comparing measures that have different scales and units of measurement.
A simpler way to create a Dual axes chart would have been to first create an Individual axes chart and then click on the dropdown of the Green pill of the secondary measure and select the Dual Axis option. Refer to the following image: