KNOWLEDGE BASE

Creating a Dual Axis Bar Chart with Multiple Measures


Published: 30 Jun 2013
Last Modified Date: 19 Nov 2017

Question

This article describes how to:

  • create a dual-axis bar chart with multiple measures.
  • differentiate each axis by color and size.
  • synchronize the two axes so that the numeric scale matches between them.

 

Environment

Tableau Desktop

Answer

Option 1

  1. Move two Measures (not Dimensions) to the Rows shelf.
  2. Right-click the second measure on the Rows shelf, and select Dual Axis.
  3. On the Marks card labeled All, set the mark type to Bar.
  4. Use the slider on the Marks card for each measure to adjust the size of each bar, so that the one layered on top is narrower than the one on the bottom.
  5. Right-click the right-side axis and select Synchronize Axis.
  6. Optionally, right-click the right-side axis and select Show Header to toggle off the labels on the right side.
  7. Switch one measure from one side to the other in the Rows shelf to move one measure foward. 

Option 2

  1. Drag Order Date to Columns
  2. Drag Sales and Profit to Rows
  3. Click the top right corner arrow on Profit and select Dual Axis.
    • Alternatively, you can right click on Profit and select Dual Axis in the view directly. 
  4. Right click on the Profit Axis and select Synchronize axis
  5. Change the mark type as desired

Option 3

  1. Drag Order Date to Columns
  2. Drag Sales to Rows
  3. Drag and drop other Measures to the Value axis

Additional Information

To view these steps in action, see the video below: 
Note: the video has no sound

 
Did this article resolve the issue?