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.

Practice

1. Which of the following best describes a vertical bar chart in Tableau?

easy

A. Dimension on Columns and Measure on Rows

B. Dimension on Rows and Measure on Columns

C. Both Dimension and Measure on Rows

D. Both Dimension and Measure on Columns

Solution

1. Step 1: Understand vertical bar chart layout

   Vertical bars are created by placing the dimension on Columns and the measure on Rows in Tableau.

2. Step 2: Match the layout to options

   Dimension on Columns and Measure on Rows matches this layout exactly.

3. Final Answer:

   Dimension on Columns and Measure on Rows -> Option A

4. Quick Check:

   Vertical bars = Dimension on Columns, Measure on Rows [OK]

Hint: Vertical bars: dimension columns, measure rows [OK]

Common Mistakes:

• Confusing horizontal and vertical bar chart layouts
• Placing both dimension and measure on the same shelf
• Swapping rows and columns incorrectly

2. Which Tableau shelf placement creates a horizontal bar chart?

easy

A. Dimension on Rows, Measure on Columns

B. Dimension on Columns, Measure on Rows

C. Measure on Rows only

D. Dimension on Rows only

Solution

1. Step 1: Recall horizontal bar chart setup

   Horizontal bars are made by placing the dimension on Rows and the measure on Columns.

2. Step 2: Identify correct option

   Dimension on Rows, Measure on Columns matches this setup exactly.

3. Final Answer:

   Dimension on Rows, Measure on Columns -> Option A

4. Quick Check:

   Horizontal bars = Dimension on Rows, Measure on Columns [OK]

Hint: Horizontal bars: dimension rows, measure columns [OK]

Common Mistakes:

• Mixing up rows and columns shelves
• Placing only measures without dimensions
• Choosing options with missing shelves

3. Given a dataset with 'Category' as dimension and 'Sales' as measure, what will be the result of placing 'Category' on Rows and 'Sales' on Columns in Tableau?

medium

A. A scatter plot comparing categories and sales

B. A horizontal bar chart showing sales per category

C. A line chart showing sales trend

D. A vertical bar chart showing sales per category

Solution

1. Step 1: Analyze shelf placement

   Category on Rows and Sales on Columns creates vertical bars representing sales per category.

2. Step 2: Identify chart type

   This layout produces a vertical bar chart, not horizontal or other chart types.

3. Final Answer:

   A vertical bar chart showing sales per category -> Option D

4. Quick Check:

   Category rows + Sales columns = vertical bars [OK]

Hint: Category rows + Sales columns = vertical bar chart [OK]

Common Mistakes:

• Assuming horizontal bars instead of vertical
• Confusing bar chart with line or scatter plot
• Ignoring shelf placement rules

4. You created a bar chart but the bars are vertical when you wanted horizontal bars. What is the most likely fix?

medium

A. Remove the dimension from the view

B. Change the mark type to Line

C. Swap the dimension and measure between Rows and Columns shelves

D. Add a filter to the data

Solution

1. Step 1: Identify cause of vertical bars

   Vertical bars appear when dimension is on Rows and measure on Columns.

2. Step 2: Fix by swapping shelves

   To get horizontal bars, swap dimension to Columns and measure to Rows.

3. Final Answer:

   Swap the dimension and measure between Rows and Columns shelves -> Option C

4. Quick Check:

   Swap shelves to switch bar orientation [OK]

Hint: Swap dimension and measure shelves to change bar direction [OK]

Common Mistakes:

• Changing mark type instead of shelf placement
• Removing dimension causing no bars
• Adding filters unrelated to orientation

5. You want to create a dashboard showing sales by region with horizontal bars, but also want to add a vertical bar chart showing profit by region side by side. How should you set up the shelves for each chart in Tableau?

hard

A. For sales: Dimension on Columns, Measure on Rows; For profit: Dimension on Rows, Measure on Columns

B. For sales: Dimension on Rows, Measure on Columns; For profit: Dimension on Columns, Measure on Rows

C. For sales: Dimension on Columns, Measure on Columns; For profit: Dimension on Rows, Measure on Rows

D. For sales: Measure on Rows, Dimension on Rows; For profit: Measure on Columns, Dimension on Columns

Solution

1. Step 1: Set up horizontal bar chart for sales

   Horizontal bars require dimension on Rows and measure on Columns.

2. Step 2: Set up vertical bar chart for profit

   Vertical bars require dimension on Columns and measure on Rows.

3. Step 3: Match options to setup

   For sales: Dimension on Rows, Measure on Columns; For profit: Dimension on Columns, Measure on Rows correctly assigns shelves for both charts.

4. Final Answer:

   For sales: Dimension on Rows, Measure on Columns; For profit: Dimension on Columns, Measure on Rows -> Option B

5. Quick Check:

   Horizontal bars = dim rows, measure columns; Vertical bars = dim columns, measure rows [OK]

Hint: Horizontal bars: dim rows; Vertical bars: dim columns [OK]

Common Mistakes:

• Using same shelf setup for both charts
• Placing measures on wrong shelves
• Confusing dimension and measure roles