Dual axes charts are useful to compare two similar types of measures that may have different types of measurement units, such as pounds and dollars. In this recipe, we will look at the dual axes chart.
Let's use the same sample file, Sample – Coffee Chain (Access)
. Open a new worksheet and select Sample – Coffee Chain (Access) as the data source.
Once the data is loaded on the sheet, perform the following steps to create a dual axes chart:
Tableau will create two vertical axes and automatically place Sales on one dual axes charts vertical axis and Budget Sales on the other. The scales on both the vertical axes are different, however. By synchronizing the axes, we get the same scales on both axes for better comparison and accurate representation of the patterns.