Dual axis charts in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a dual axis chart by adding a second measure to the Rows shelf and then {{BLANK_1}} the axes.

Tableau

Drag the first measure to Rows shelf, then drag the second measure to Rows shelf next to the first. Right-click on the second measure's axis and select '[1]'.

Drag options to blanks, or click blank then click option'

AAdd Reference Line

BDual Axis

CSynchronize Axis

DCombine Axis

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Synchronize Axis' instead of 'Dual Axis' at this step.

Trying to drag the second measure to Columns shelf instead of Rows shelf.

To create a dual axis chart in Tableau, you add the second measure to the Rows shelf and then right-click the second axis and choose Dual Axis. This overlays the two charts on the same axis area.

2fill in blank

medium

Complete the step to make sure both axes show the same scale by right-clicking the second axis and selecting '{{BLANK_1}}'.

Tableau

After creating the dual axis chart, right-click on the second axis and choose '[1]' to align scales.

Drag options to blanks, or click blank then click option'

ASynchronize Axis

BEdit Axis

CDual Axis

DAdd Reference Line

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Dual Axis' again instead of 'Synchronize Axis'.

Not synchronizing axes, causing confusing scales.

Synchronizing axes ensures both measures use the same scale, making the dual axis chart easier to read.

3fill in blank

hard

Fix the error in the following step: To format the dual axis chart, you must {{BLANK_1}} the marks card for each axis separately.

Tableau

After creating the dual axis chart, click on the [1] card to format colors and shapes for each measure.

Drag options to blanks, or click blank then click option'

AMarks

BColumns

CRows

DFilters

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to format the Rows or Columns shelf instead of the Marks card.

Looking for a single Marks card instead of one per axis.

The Marks card controls the appearance of each measure's marks. For dual axis charts, you format each axis's marks card separately.

4fill in blank

hard

Fill both blanks to complete the steps to remove the extra axis and clean the view: Right-click on the {{BLANK_1}} axis and select {{BLANK_2}}.

Tableau

To clean the dual axis chart, right-click on the [1] axis and select [2] to hide it.

Drag options to blanks, or click blank then click option'

Asecondary

Bprimary

CShow Header

DHide Header

Attempts:

3 left

💡 Hint

Common Mistakes

Hiding the primary axis instead of the secondary axis.

Selecting 'Show Header' which does the opposite.

In dual axis charts, the secondary axis is often hidden by right-clicking it and choosing 'Hide Header' to reduce clutter.

5fill in blank

hard

Fill all three blanks to complete the steps to synchronize and format dual axis charts: Right-click on the {{BLANK_1}} axis and select {{BLANK_2}}. Then, click on the {{BLANK_3}} card to adjust colors and shapes.

Tableau

Right-click on the [1] axis and select [2]. Then, click on the [3] card to customize the marks.

Drag options to blanks, or click blank then click option'

Asecondary

BSynchronize Axis

CMarks

DRows

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to synchronize the primary axis.

Using the Rows shelf instead of the Marks card for formatting.

Synchronize the secondary axis to align scales, then use the Marks card to format each measure's appearance.

Practice

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

easy

A. To filter data based on two conditions

B. To create two separate charts side by side

C. To compare two different measures on the same graph using two axes

D. To combine two dimensions into one axis

Solution

1. Step 1: Understand what dual axis means

   A dual axis chart shows two measures on one graph but with two separate axes, usually one on the left and one on the right.

2. Step 2: Compare options with this definition

   Only To compare two different measures on the same graph using two axes describes comparing two measures on the same graph using two axes, which matches the definition.

3. Final Answer:

   To compare two different measures on the same graph using two axes -> Option C

4. Quick Check:

   Dual axis = compare two measures on one graph [OK]

Hint: Dual axis means two measures, two axes on one chart [OK]

Common Mistakes:

• Thinking dual axis creates two separate charts
• Confusing dual axis with filtering
• Mixing up dimensions and measures

2. Which of the following is the correct way to create a dual axis chart in Tableau?

easy

A. Drag one measure to Filters and one measure to Tooltip, then select 'Dual Axis'

B. Drag one measure to Columns and one dimension to Rows, then select 'Dual Axis'

C. Drag two dimensions to Rows shelf and select 'Dual Axis'

D. Drag two measures to Rows shelf, right-click second measure, and select 'Dual Axis'

Solution

1. Step 1: Recall the dual axis creation steps

   To create a dual axis chart, you drag two measures to the Rows or Columns shelf, then right-click the second measure and choose 'Dual Axis'.

2. Step 2: Check each option

   Drag two measures to Rows shelf, right-click second measure, and select 'Dual Axis' matches the correct method. The other options misuse dimensions or shelves and do not create dual axis charts.

3. Final Answer:

   Drag two measures to Rows shelf, right-click second measure, and select 'Dual Axis' -> Option D

4. Quick Check:

   Drag two measures + Dual Axis = correct method [OK]

Hint: Drag two measures, right-click second, pick 'Dual Axis' [OK]

Common Mistakes:

• Using dimensions instead of measures for dual axis
• Trying to dual axis with filters or tooltips
• Not right-clicking the second measure

3. Given a dual axis chart with Sales on the left axis and Profit on the right axis, what happens if you do NOT synchronize the axes?

medium

A. The chart will show an error and not display

B. The two measures may appear on different scales, making comparison misleading

C. Both axes will automatically use the same scale

D. The marks for both measures will merge into one

Solution

1. Step 1: Understand axis synchronization

   Synchronizing axes means making both axes use the same scale so the measures can be compared fairly.

2. Step 2: Consider what happens without synchronization

   Without synchronization, each axis uses its own scale, so the measures may look very different even if values are similar, causing misleading visuals.

3. Final Answer:

   The two measures may appear on different scales, making comparison misleading -> Option B

4. Quick Check:

   Unsynchronized axes = different scales, misleading comparison [OK]

Hint: Unsync axes = different scales, hard to compare [OK]

Common Mistakes:

• Assuming Tableau auto-syncs axes always
• Thinking chart shows error without sync
• Believing marks merge automatically

4. You created a dual axis chart but the marks for the second measure do not appear. What is the most likely cause?

medium

A. You did not assign a mark type to the second axis

B. You forgot to synchronize the axes

C. You dragged a dimension instead of a measure for the second axis

D. You did not drag the second measure to the Tooltip shelf

Solution

1. Step 1: Check mark types for dual axis

   Each axis in a dual axis chart needs a mark type (like bar, line) assigned to show its data points.

2. Step 2: Identify why marks might be missing

   If the second axis has no mark type assigned, its marks won't display even if data is present.

3. Final Answer:

   You did not assign a mark type to the second axis -> Option A

4. Quick Check:

   No mark type = no marks shown [OK]

Hint: Assign mark type to each axis to show marks [OK]

Common Mistakes:

• Confusing axis sync with mark visibility
• Dragging dimensions instead of measures
• Thinking Tooltip shelf controls marks

5. You want to create a dual axis chart comparing monthly Sales (as bars) and Profit Ratio (as a line) over a year. Which steps correctly achieve this?

hard

A. Drag Sales and Profit Ratio to Rows, right-click Profit Ratio and select 'Dual Axis', then set Sales marks to Bar and Profit Ratio marks to Line

B. Drag Sales to Columns and Profit Ratio to Rows, then combine using 'Dual Axis', set both marks to Bar

C. Drag Sales and Profit Ratio to Rows, synchronize axes, then set both marks to Line

D. Drag Sales to Rows, Profit Ratio to Tooltip, then select 'Dual Axis' and set marks to Bar and Line

Solution

1. Step 1: Place both measures on Rows shelf

   Drag Sales and Profit Ratio to Rows to prepare for dual axis.

2. Step 2: Create dual axis and assign mark types

   Right-click Profit Ratio and select 'Dual Axis' to combine. Then set Sales marks to Bar and Profit Ratio marks to Line for clarity.

3. Final Answer:

   Drag Sales and Profit Ratio to Rows, right-click Profit Ratio and select 'Dual Axis', then set Sales marks to Bar and Profit Ratio marks to Line -> Option A

4. Quick Check:

   Dual axis + different marks = clear comparison [OK]

Hint: Dual axis + set different marks for clarity [OK]

Common Mistakes:

• Not setting different mark types for clarity
• Dragging measures to different shelves incorrectly
• Using Tooltip shelf instead of Rows or Columns