Tableau: Creating Interactive Data Visualizations

Creating dual axes charts

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.

Getting ready

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.

How to do it...

Once the data is loaded on the sheet, perform the following steps to create a dual axes chart:

1. Click on the Show Me button to bring the Show Me toolbar on the screen.
2. While holding the Ctrl key, click on Date, Type, and Market from Dimensions and Sales and Budget Sales from Measures.
3. Click on the dual line graph icon on the Show Me toolbar.
4. Click-and-drag ...