Combo charts (bar + line) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Create a Combo Chart with Sales and Profit

You have a dataset with monthly Sales and Profit values. You want to create a combo chart where Sales is shown as bars and Profit as a line on the same axis.

Which step is essential to combine these two measures correctly in Tableau?

A Drag both Sales and Profit to Rows shelf and then select 'Dual Axis' to overlay the charts.

B Use the Pages shelf to animate Sales and Profit over time.

C Create two separate worksheets and place them side by side on a dashboard.

D Place Sales on Columns shelf and Profit on Filters shelf to filter the data.

💡 Hint

Think about how to overlay two different chart types on the same axis.

To create a combo chart in Tableau, you drag both measures to the Rows shelf and then right-click one axis to select 'Dual Axis'. This overlays the two charts, allowing one to be bars and the other a line.

❓ dax_lod_result

intermediate

Calculate Combined Sales and Profit Ratio

You want to create a calculated measure in Tableau that shows the ratio of total Profit to total Sales for each category. Which formula will give the correct result?

A SUM([Sales]) / SUM([Profit])

B AVG([Profit]) / AVG([Sales])

C SUM([Profit]) / SUM([Sales])

D COUNT([Profit]) / COUNT([Sales])

💡 Hint

Think about how to get total profit divided by total sales.

To get the ratio of total Profit to total Sales, you sum each measure and then divide. Using averages or counts would not give the correct ratio.

❓ data_modeling

advanced

Handling Different Granularities in Combo Charts

You have sales data at the daily level and profit data aggregated monthly. You want to create a combo chart showing daily sales bars and monthly profit line. What is the best approach to handle this in Tableau?

A Use the daily date for sales and ignore the profit data granularity difference.

B Create a calculated field to aggregate daily sales to monthly level before combining with profit.

C Blend the data sources without adjusting granularity and plot both directly.

D Create two separate charts and do not combine them.

💡 Hint

Think about matching the time levels before combining data.

To combine data with different granularities, you must aggregate the finer data (daily sales) to the coarser level (monthly) to align with profit data. This ensures the combo chart is accurate.

🔧 Formula Fix

advanced

Fixing Misaligned Axes in Combo Chart

You created a combo chart with Sales as bars and Profit as a line using dual axis. However, the two axes scales are very different, making the line hard to interpret. What is the best way to fix this?

A Synchronize the axes by right-clicking one axis and selecting 'Synchronize Axis'.

B Change the mark type of both measures to bars.

C Remove the dual axis and use a single axis instead.

D Filter out extreme profit values to reduce scale difference.

💡 Hint

Think about how to make both axes use the same scale.

Synchronizing axes aligns the scales of both measures, making the combo chart easier to read. Changing mark types or filtering data does not solve the scale mismatch.

🧠 Conceptual

expert

Best Practice for Color Use in Combo Charts

When designing a combo chart with bars and lines, what is the best practice for using colors to ensure clarity and accessibility?

A Use the same color for both bars and lines to keep the chart simple.

B Use many different colors for each data point to show detail.

C Use bright neon colors for both marks to attract attention.

D Use distinct colors with high contrast for bars and lines, and ensure colorblind-friendly palettes.

💡 Hint

Think about how to make the chart readable for everyone.

Using distinct, high-contrast colors helps differentiate chart elements. Choosing colorblind-friendly palettes ensures accessibility. Using the same or too many colors reduces clarity.

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