Bar charts (horizontal and vertical) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct way to create a horizontal bar chart in Tableau

You have sales data by product category. You want to create a horizontal bar chart showing total sales per category. Which option correctly describes how to create this chart?

A Drag 'Sales' to Columns and 'Category' to Rows, then change the mark type to Circle.

B Drag 'Sales' to Rows and 'Category' to Columns, then change the mark type to Line.

C Drag 'Category' to Rows and 'Sales' to Columns, then change the mark type to Bar.

D Drag 'Category' to Columns and 'Sales' to Rows, then change the mark type to Bar.

💡 Hint

Think about which axis controls the categories and which controls the values for a horizontal bar chart.

In Tableau, to create a horizontal bar chart, categories go on Rows and the measure (Sales) goes on Columns with the mark type set to Bar.

❓ visualization

intermediate

Determine the correct setup for a vertical bar chart in Tableau

You want to create a vertical bar chart showing total profit by region. Which option correctly describes how to build this chart?

A Drag 'Region' to Columns and 'Profit' to Rows, then set mark type to Bar.

B Drag 'Profit' to Columns and 'Region' to Rows, then set mark type to Bar.

C Drag 'Region' to Rows and 'Profit' to Columns, then set mark type to Line.

D Drag 'Profit' to Rows and 'Region' to Columns, then set mark type to Circle.

💡 Hint

Vertical bars grow upward along the Rows axis.

For vertical bar charts in Tableau, categories go on Columns and the measure on Rows with mark type Bar.

🧠 Conceptual

advanced

Why choose horizontal over vertical bar charts?

Which reason best explains when to prefer a horizontal bar chart instead of a vertical bar chart?

A When you want to compare percentages stacked on top of each other.

B When category names are long and need more space to display clearly.

C When you want to show time series data over months.

D When you want to display data with very few categories.

💡 Hint

Think about label readability and space.

Horizontal bar charts are better for long category names because labels can be read easily along the vertical axis.

🔧 Formula Fix

advanced

Identify the error causing a vertical bar chart to display as a line chart

You created a chart with 'Category' on Columns and 'Sales' on Rows, but the chart shows lines instead of bars. What is the most likely cause?

A The data source is missing the 'Sales' field.

B The 'Sales' field is on Columns instead of Rows.

C The 'Category' field is on Rows instead of Columns.

D The mark type is set to Line instead of Bar.

💡 Hint

Check the mark type setting in the Marks card.

If the mark type is set to Line, Tableau will draw lines instead of bars even if the fields are placed correctly.

🎯 Scenario

expert

Design a dashboard with both horizontal and vertical bar charts for sales and profit

You need to build a dashboard showing total sales by product category as a horizontal bar chart and total profit by region as a vertical bar chart. Which setup correctly achieves this?

A Create one worksheet with 'Category' on Rows and 'Sales' on Columns (mark type Bar), another worksheet with 'Region' on Columns and 'Profit' on Rows (mark type Bar), then add both to the dashboard.

B Create one worksheet with 'Category' on Columns and 'Sales' on Rows (mark type Bar), another worksheet with 'Region' on Rows and 'Profit' on Columns (mark type Bar), then add both to the dashboard.

C Create one worksheet with 'Sales' on Rows and 'Category' on Columns (mark type Line), another worksheet with 'Profit' on Columns and 'Region' on Rows (mark type Circle), then add both to the dashboard.

D Create one worksheet with 'Category' on Rows and 'Sales' on Columns (mark type Circle), another worksheet with 'Region' on Columns and 'Profit' on Rows (mark type Line), then add both to the dashboard.

💡 Hint

Remember the axis placement for horizontal and vertical bar charts and mark types.

Horizontal bar chart: Category on Rows, Sales on Columns, mark type Bar.
Vertical bar chart: Region on Columns, Profit on Rows, mark type Bar.
Adding both worksheets to a dashboard shows both charts correctly.