Dual axis charts in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a dual axis chart in Tableau?

A dual axis chart in Tableau is a visualization that combines two different measures on the same graph using two vertical axes, allowing comparison of different data types or scales in one view.

beginner

How do you create a dual axis chart in Tableau?

To create a dual axis chart, drag two measures to the Rows or Columns shelf, then right-click the second measure's axis and select 'Dual Axis'. This overlays the two charts sharing the same axis space.

intermediate

Why should you synchronize axes in a dual axis chart?

Synchronizing axes ensures both measures use the same scale, making it easier to compare values accurately without misleading differences caused by different axis ranges.

beginner

What is a common use case for dual axis charts?

A common use case is comparing sales and profit over time, where sales might be shown as bars and profit as a line, helping to see trends and relationships clearly.

intermediate

What is a potential pitfall when using dual axis charts?

A pitfall is confusing viewers if the two axes are not clearly labeled or if the scales differ too much, which can lead to misinterpretation of the data.

What does a dual axis chart allow you to do in Tableau?

A Combine two dimensions into one axis

B Create two separate charts side by side

C Filter data based on two conditions

D Display two measures on the same graph with separate axes

Dual axis charts overlay two measures on the same graph using two vertical axes.

How do you synchronize axes in a dual axis chart?

A Right-click one axis and select 'Synchronize Axis'

B Drag both measures to the same shelf

C Use the filter pane

D Change the chart type

You synchronize axes by right-clicking one axis and choosing 'Synchronize Axis' to align scales.

Which chart types are commonly combined in a dual axis chart?

A Tree map and box plot

B Bar and line

C Histogram and map

D Pie and scatter

Bar and line charts are often combined to show different measures clearly.

What should you always do to avoid confusion in dual axis charts?

A Hide one axis

B Use only one color

C Label both axes clearly

D Use the same chart type for both measures

Clear axis labels help viewers understand what each axis represents.

When is a dual axis chart NOT recommended?

A When measures have very different scales and cannot be synchronized

B When comparing two related measures

C When showing trends over time

D When you want to save space on the dashboard

If scales differ too much and can't be synchronized, dual axis charts can mislead viewers.

Explain how to create and use a dual axis chart in Tableau.

Think about combining two measures visually on one graph.

Describe the benefits and challenges of using dual axis charts.

Consider what makes dual axis charts helpful and what to watch out for.