Creating a Dual Axis Chart in Tableau
Suppose you want to create a line chart that lets you compare sales and profits over a given period. One approach is to have two separate charts on the same view, one on top of the other:
That works, but we could make it more compact by turning it into a dual axis chart:
Here's how:
- Drag a date dimension to the columns shelf.
- Drag two measures you want to compare into the rows shelf, such as "Sales" and "Profit".
- Right-click the y-axis of the second measure and select
Dual Axis
. - You may find that the new y-axis that appears doesn't match up with the original. To correct this, right-click either y-axis and select
Synchronize Axis
.