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

Published: 28 Mar 2016
Last Modified Date: 20 Jul 2023

Question

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

Environment

Tableau Desktop

Answer

The following instructions can be reviewed in the attached workbook.

Drag a dimension to the Columns shelf (for example: Order date by Month)
Drag the measure that will be the bar chart to the Rows shelf (for example: Sales)
Drag the Measure Values field to the Rows shelf.
Right-click on Measure Values in the Rows shelf and select Dual Axis.
Right-click again on Measure Values in the Rows shelf and select Filter.
Select only the measures to be included in the view as the alternate mark type.
In the Marks card, select Measure Value.
Choose the type of mark to be used (for example, Bar Chart for Sales and Lines for Measure Values).

To view the above steps in action, see the video below.
Note: the video has no sound. To view the video in higher quality, click the YouTube icon below to watch it on YouTube directly.

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.