KNOWLEDGE BASE

Creating a Graph that Combines a Bar Chart with Two or More Lines


Published: 28 Mar 2016
Last Modified Date: 20 Jun 2017

Question

How to create a graph that combines a bar chart with two or more lines.

Environment

Tableau Desktop 9.0.0

Answer

The following instructions can be reviewed in the attached workbook.
  1. Drag a dimension to the Columns shelf.
  2. Drag the measure that will be the bar chart to the Rows shelf.
  3. Drag the Measure Values field to the Rows shelf.
  4. Right-click on Measure Values in the Rows shelf and select Dual Axis.
  5. Right-click again on Measure Values in the Rows shelf and select Filter.
  6. Select only the measures to be included in the view as the alternate mark type.
  7. In the Marks card, select Measure Value.
  8. Choose the type of mark to be used.

Additional Information

To display a certain text above the line graph (such as a Percent Total - %), add a table calculation to the measure (right-click the measure > select Add Quick Table calculation > Percent Total) and ensure the measure is also added to the Text mark. 
Did this article resolve the issue?