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

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.

Practice

1. What is the main purpose of a combo chart in Tableau?

easy

A. To filter data based on categories

B. To create a pie chart with multiple slices

C. To show only one measure as a bar chart

D. To display two different types of data using bars and lines together

Solution

1. Step 1: Understand combo chart definition

   A combo chart combines two chart types, usually bars and lines, to show different data types together.

2. Step 2: Identify the purpose in Tableau

   In Tableau, combo charts help compare two measures visually by using bars for one and lines for another.

3. Final Answer:

   To display two different types of data using bars and lines together -> Option D

4. Quick Check:

   Combo chart = bars + lines [OK]

Hint: Combo charts mix bars and lines to compare two data types [OK]

Common Mistakes:

• Thinking combo charts show only one measure
• Confusing combo charts with pie charts
• Believing combo charts filter data

2. Which step is necessary to create a combo chart in Tableau?

easy

A. Use dual axis and set different mark types for each measure

B. Create a calculated field with IF statements

C. Apply a filter to exclude null values

D. Use a single axis with one mark type

Solution

1. Step 1: Identify how to combine bars and lines

   To combine bars and lines, Tableau requires dual axes so each measure can have its own scale and mark type.

2. Step 2: Set mark types for each axis

   After dual axis, set one axis to bar marks and the other to line marks to create the combo effect.

3. Final Answer:

   Use dual axis and set different mark types for each measure -> Option A

4. Quick Check:

   Dual axis + mark types = combo chart [OK]

Hint: Dual axis + different marks = combo chart in Tableau [OK]

Common Mistakes:

• Trying to use one axis for both bars and lines
• Confusing filters or calculations with combo chart setup
• Not setting mark types separately

3. Given a combo chart with Sales as bars and Profit Ratio as a line, what happens if axes are not synchronized?

medium

A. The chart will show an error and not render

B. The line and bars may appear misaligned, confusing interpretation

C. The bars will disappear but the line remains

D. The line will convert to bars automatically

Solution

1. Step 1: Understand axis synchronization

   When axes are not synchronized, the scales differ, causing bars and lines to not align properly.

2. Step 2: Effect on visualization

   This misalignment makes it hard to compare values visually, confusing the viewer.

3. Final Answer:

   The line and bars may appear misaligned, confusing interpretation -> Option B

4. Quick Check:

   Unsynced axes = misaligned chart [OK]

Hint: Always sync axes to align bars and lines clearly [OK]

Common Mistakes:

• Expecting an error instead of misalignment
• Thinking bars or lines disappear
• Assuming automatic mark type changes

4. You created a combo chart but the line chart is not visible. What is the most likely cause?

medium

A. The second axis is not added or dual axis is not enabled

B. The data source has no values for the line measure

C. The bar chart is overlapping the line chart due to mark size

D. The filter excludes all data points for the bar chart

Solution

1. Step 1: Check dual axis setup

   If the line is missing, often the second axis for the line measure was not added or dual axis was not enabled.

2. Step 2: Confirm mark types and axes

   Without dual axis, Tableau cannot overlay line and bar marks properly, so the line won't show.

3. Final Answer:

   The second axis is not added or dual axis is not enabled -> Option A

4. Quick Check:

   Missing line = no dual axis [OK]

Hint: Enable dual axis to show both bars and lines [OK]

Common Mistakes:

• Assuming data is missing without checking axes
• Blaming filters for line missing
• Not verifying mark types

5. You want to create a combo chart showing monthly Sales as bars and cumulative Profit as a line. Which steps should you follow?

hard

A. Use a pie chart for Sales and a line chart for Profit on the same axis

B. Create cumulative Profit bar chart, add Sales as line on single axis, no synchronization needed

C. Create Sales bar chart, create cumulative Profit calculated field, add Profit as line on dual axis, synchronize axes

D. Create Sales and Profit as separate charts, then combine in dashboard without dual axis

Solution

1. Step 1: Prepare measures

   Create a bar chart for Sales and a calculated field for cumulative Profit to show running total.

2. Step 2: Build combo chart

   Add Sales as bars and cumulative Profit as a line on a dual axis, then synchronize axes for clear comparison.

3. Final Answer:

   Create Sales bar chart, create cumulative Profit calculated field, add Profit as line on dual axis, synchronize axes -> Option C

4. Quick Check:

   Dual axis + cumulative calc + sync axes = correct combo [OK]

Hint: Use dual axis and cumulative calc for combo charts with running totals [OK]

Common Mistakes:

• Not creating cumulative calculated field for Profit
• Skipping axis synchronization
• Using single axis for different scales