Question
How to create a bar-in-bar chart with one line graph (three measure values in one view).
Last Modified Date: 16 Aug 2023
Environment
- Tableau Desktop
Answer
A packaged workbook and a video can be found in the Attachments section to the right of this text which will allow you to follow along with the steps below.Steps:
- Drag a dimension to the Columns shelf (in this example: [Order Date] by Month)
- Drag a measure that will be the Bar chart to the Rows shelf (in this example: [Sales])
- Drag another measure that will be the Bar chart into the right axis of the view (in this example: [Profit])
- Drag [Measure Names] off the Columns shelf
- Drag the third measure that will be the Line graph, to the Rows shelf (in this example: [Quantity])
- Right-click on the third measure in the Rows shelf and select Dual Axis.
- In the Marks card, select the third measure (in this example: [Quantity])
- Choose Line as the chart type
- Set Analysis > Stack Marks as Off
- In the Marks card, select Measure Value
- Choose Bar as the chart type
- Drag Measure Names to Size
Additional Information
To display three or more measures in a view, try to combine "Measure Values" and "Dual Axis" together and add "Measure Names" on the Marks shelf.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials