KNOWLEDGE BASE

Creating a Graph that Combines a Bar-in-Bar Chart with a Line Graph


Published: 07 Jul 2020
Last Modified Date: 08 Jul 2020

Question

How to create a Bar-in-Bar chart with one Line graph (three measure values in one view).

Environment

  • Tableau Desktop

Answer

Steps:
  1. Drag a dimension to the Columns shelf (in this example: [Order Date] by Month)
  2. Drag a measure that will be the Bar chart to the Rows shelf (in this example: [Sales])
  3. Drag another measure that will be the Bar chart into the right axis of the view (in this example: [Profit])
  4. Drag [Measure Names] off the Column shelf
  5. Drag the third measure that will be the Line graph to the Rows shelf (in this example: [Quantity])
  6. Right-click on the third measure in the Rows shelf and select Dual Axis.
  7. In the Marks card, select the third measure(in this example: [Quantity])
  8. Choose the [Line] as the chart type
  9. Set [Analysis] > [Stack Marks] as[Off]
  10. In the Marks card, select Measure Value
  11. Choose the [Bar] as the chart type
  12. Drag [Measure Names] to [Size]
To view the above steps in action, see the video below.

Additional Information

To display three or more measures in a view, try to combine "Measure Values" and "Dual Axis" together and add "Measure Names" in Mark Shelf.
Did this article resolve the issue?