Synchronizing axes in Tableau - Step-by-Step Guide

Introduction

Synchronizing axes in Tableau helps you compare two measures on the same scale. It solves the problem of misleading visuals when two charts have different axis ranges.

When you want to compare sales and profit trends on the same timeline clearly.

When you have two related measures like temperature and humidity and want to see their patterns together.

When you create a dual-axis chart and want both axes to show the same scale for easy comparison.

When you want to avoid confusion caused by different axis ranges in combined charts.

When you want to highlight the relationship between two measures visually.

Steps

Step 1: Drag the first measure to Rows or Columns shelf

- Tableau worksheet

The first chart appears with its own axis

💡 Start with the main measure you want to compare

Step 2: Drag the second measure to the same shelf (Rows or Columns) as the first measure

- Tableau worksheet

A second chart appears next to the first one

💡 This creates two separate axes initially

Step 3: Right-click the second measure's axis

- Axis area on the worksheet

A context menu appears

💡 Make sure you click exactly on the axis numbers

Step 4: Select 'Dual Axis' from the context menu

- Context menu on second axis

Both measures appear on the same chart with two axes

💡 This overlays the two charts

Step 5: Right-click the second axis again

- Second axis on the dual-axis chart

Context menu appears again

💡 This is to synchronize the scales

Step 6: Select 'Synchronize Axis'

- Context menu on second axis

Both axes use the same scale, making comparison easier

💡 If this option is greyed out, check that both measures have compatible data types

Step 7: Format or hide one axis if needed

- Axis formatting options or right-click axis and select 'Show Header' to toggle

Chart looks cleaner with one visible axis

💡 Hiding one axis avoids clutter

Before vs After

Before

Two separate charts with different axis scales: Sales axis from 0 to 1000, Profit axis from 0 to 200

After

One combined chart with dual axes synchronized from 0 to 1000, making sales and profit trends easy to compare

Settings Reference

Dual Axis

📍 Right-click on the second measure's axis in the worksheet

To overlay two charts on the same view

Default: Disabled

Synchronize Axis

📍 Right-click on the second axis after enabling Dual Axis

To make both axes use the same scale for accurate comparison

Default: Disabled

Show Header

📍 Right-click on an axis

To display or hide the axis labels and numbers

Default: Show

Common Mistakes

Trying to synchronize axes before enabling Dual Axis

The 'Synchronize Axis' option is only available after Dual Axis is enabled

First enable Dual Axis, then right-click the second axis to select 'Synchronize Axis'

Using measures with incompatible data types for synchronization

Axes cannot synchronize if measures are not comparable (e.g., date and number)

Ensure both measures are numeric and represent comparable data before synchronizing

Not hiding one axis after synchronization

Shows duplicate axis labels which can confuse viewers

Right-click one axis and uncheck 'Show Header' to hide it for a cleaner look

Summary

Synchronizing axes lets you compare two measures on the same scale in one chart.

You must enable Dual Axis first, then synchronize the axes.

Hide one axis after synchronization to keep the chart clear and easy to read.

Practice

1. What is the main purpose of synchronizing axes in Tableau when using dual-axis charts?

easy

A. To filter data based on axis values

B. To create separate charts for each measure

C. To change the color of the axes

D. To align multiple measures on the same scale for easier comparison

Solution

1. Step 1: Understand dual-axis charts

   Dual-axis charts combine two measures on one view but may have different scales.

2. Step 2: Purpose of synchronizing axes

   Synchronizing axes aligns these scales so the measures can be compared directly.

3. Final Answer:

   To align multiple measures on the same scale for easier comparison -> Option D

4. Quick Check:

   Synchronizing axes = aligned scales [OK]

Hint: Synchronize axes to compare measures on the same scale [OK]

Common Mistakes:

• Thinking it changes colors
• Believing it filters data
• Assuming it creates separate charts

2. Which of the following is the correct way to enable axis synchronization in Tableau for a dual-axis chart?

easy

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

B. Drag one measure over the other measure in the data pane

C. Use the 'Filter' shelf to synchronize axes

D. Change the mark type to 'Bar'

Solution

1. Step 1: Locate axis options

   In a dual-axis chart, right-clicking an axis shows options related to that axis.

2. Step 2: Enable synchronization

   Selecting 'Synchronize Axis' aligns the scales of both axes.

3. Final Answer:

   Right-click on one axis and select 'Synchronize Axis' -> Option A

4. Quick Check:

   Right-click axis -> Synchronize Axis [OK]

Hint: Right-click axis to find 'Synchronize Axis' option [OK]

Common Mistakes:

• Trying to drag measures to synchronize
• Using filters to sync axes
• Changing mark types instead

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

medium

A. Sales and Profit will be shown on different scales, making direct comparison difficult

B. Both measures will be combined into a single measure

C. The chart will show an error and not render

D. The axes will automatically synchronize anyway

Solution

1. Step 1: Understand dual-axis without synchronization

   Without synchronization, each axis uses its own scale based on its data range.

2. Step 2: Effect on comparison

   This causes Sales and Profit to appear on different scales, making it hard to compare values visually.

3. Final Answer:

   Sales and Profit will be shown on different scales, making direct comparison difficult -> Option A

4. Quick Check:

   Unsynchronized axes = different scales [OK]

Hint: No sync means different scales, hard to compare [OK]

Common Mistakes:

• Thinking measures combine automatically
• Expecting an error to occur
• Assuming axes sync by default

4. You created a dual-axis chart but the 'Synchronize Axis' option is grayed out. What is the most likely cause?

medium

A. The chart type is set to pie chart

B. You forgot to add a filter to the view

C. One or both axes are using discrete (categorical) fields instead of continuous fields

D. The data source is not connected

Solution

1. Step 1: Check field types for axes

   Synchronizing axes requires continuous fields because only continuous axes have numeric scales.

2. Step 2: Identify why option is disabled

   If one or both axes use discrete fields, the option to synchronize is disabled (grayed out).

3. Final Answer:

   One or both axes are using discrete (categorical) fields instead of continuous fields -> Option C

4. Quick Check:

   Discrete fields disable sync option [OK]

Hint: Sync needs continuous fields, not discrete [OK]

Common Mistakes:

• Thinking filters affect sync availability
• Assuming data connection causes this
• Confusing chart types with axis sync

5. You want to create a combined line and bar chart in Tableau showing Sales (bar) and Profit (line) on the same view. How do you ensure the axes are synchronized for accurate comparison?

hard

A. Place Sales and Profit on separate sheets and combine them in a dashboard

B. Create a dual-axis chart, set Sales as bar, Profit as line, then right-click Profit axis and select 'Synchronize Axis'

C. Use a filter to show only Sales or Profit at a time

D. Change both measures to discrete fields before creating the chart

Solution

1. Step 1: Build dual-axis chart with different mark types

   Drag Sales and Profit to Rows, create dual-axis, assign Sales to bar and Profit to line marks.

2. Step 2: Synchronize axes for scale alignment

   Right-click the Profit axis and select 'Synchronize Axis' to align scales for comparison.

3. Final Answer:

   Create a dual-axis chart, set Sales as bar, Profit as line, then right-click Profit axis and select 'Synchronize Axis' -> Option B

4. Quick Check:

   Dual-axis + sync axis = aligned combined chart [OK]

Hint: Dual-axis + sync axis for combined bar and line chart [OK]

Common Mistakes:

• Using separate sheets instead of dual-axis
• Filtering measures instead of syncing axes
• Changing measures to discrete disables sync