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.