0
0
Tableaubi_tool~5 mins

Combo charts (bar + line) in Tableau - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Combo charts combine bars and lines in one view to compare two types of data clearly. This helps when you want to see how one measure changes alongside another in the same chart.
When you want to show sales volume as bars and profit margin as a line on the same chart.
When comparing monthly revenue (bars) with customer satisfaction scores (line) over time.
When you need to highlight trends in one measure while showing actual values of another.
When presenting budget vs actual spending with bars and a target line.
When you want to combine counts and percentages in one visual for easy comparison.
Steps
Step 1: Open your Tableau workbook and go to a new worksheet
- Tableau workspace
A blank worksheet appears ready for building your chart
Step 2: Drag the dimension you want to analyze (e.g., Date) to the Columns shelf
- Columns shelf
The column axis is set with your chosen dimension
Step 3: Drag the first measure (e.g., Sales) to the Rows shelf
- Rows shelf
A bar chart appears showing the first measure
Step 4: Drag the second measure (e.g., Profit Margin) to the right side of the Rows shelf until you see a double axis indicator, then drop it
- Rows shelf
A second axis appears on the right, and the chart shows two measures overlaid
Step 5: Right-click on the second measure's axis and select 'Dual Axis'
- Second measure axis
Both measures share the same horizontal axis but have separate vertical axes
Step 6: On the Marks card, select the mark type for the first measure as 'Bar' and for the second measure as 'Line'
- Marks card
The first measure displays as bars and the second as a line on the same chart
Step 7: Right-click on one of the axes and select 'Synchronize Axis' if scales should match
- Axis context menu
Both axes align to the same scale for easier comparison
Before vs After
Before
A worksheet with a bar chart showing sales over months only
After
A combo chart showing sales as bars and profit margin as a line over the same months with dual axes
Settings Reference
Dual Axis
📍 Right-click on second measure axis
Allows two measures to share the same dimension axis but have separate value axes
Default: Single Axis
Mark Type
📍 Marks card for each measure
Defines how each measure is visually represented in the combo chart
Default: Automatic
Synchronize Axis
📍 Right-click on axis
Aligns the scales of both axes for better visual comparison
Default: Unsynchronized
Common Mistakes
Not using dual axis and just placing two measures on rows
This creates two separate charts stacked vertically, not a combined view
Use dual axis to overlay the two measures on the same chart area
Forgetting to set different mark types for each measure
Both measures show as the same chart type, losing the combo effect
Set one measure to Bar and the other to Line on the Marks card
Not synchronizing axes when scales are similar
Axes scales differ, making comparison confusing
Right-click axis and choose Synchronize Axis for aligned scales
Summary
Combo charts in Tableau show two measures together using bars and lines for clear comparison.
Use dual axis and set different mark types to create the combo effect.
Synchronize axes when needed to make the chart easier to read.