Victoria's Notes

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:

Tableau: Two charts comparing sales with profit

That works, but we could make it more compact by turning it into a dual axis chart:

Tableau: A dual axis chart comparing sales with profit

Here's how:

  1. Drag a date dimension to the columns shelf.
  2. Drag two measures you want to compare into the rows shelf, such as "Sales" and "Profit".
  3. Right-click the y-axis of the second measure and select Dual Axis.
  4. 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.