How to Synchronize Axis in Tableau

Displaying two different metrics on the same chart in Tableau is a fantastic way to compare performance, but if you're not careful, it can create a seriously misleading picture. The key to an honest and accurate visualization is to synchronize your axes. This article will walk you through exactly how and why to do it, and perhaps more importantly, when you shouldn’t.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why You Need to Synchronize Axes in Tableau

A dual-axis chart combines two independent charts by overlaying them on top of each other. This is incredibly useful for comparing measures that might have different scales, like displaying Sales (in dollars) and Quantity (a simple count) over time. You get two y-axes - one on the left and one on the right - each scaled independently to fit the data for its corresponding measure.

Here’s the trap: When the measures are conceptually similar (like Sales and Profit), independent scales can distort reality. Tableau's default behavior is to have each axis automatically scale to best fit its data. This can make small numbers look big and big numbers look small, depending on the range.

A Classic Example of a Misleading Chart

Imagine you're charting monthly Sales and Profit. Your sales for June were $50,000, and your profit was $5,000. On a dual-axis chart with unsynchronized axes, Tableau might scale the Sales axis from $0 to $60,000 and the Profit axis from $0 to $6,000.

Visually, the data point for $50,000 Sales would be very high up on its axis (at about 83% of the total height). The data point for $5,000 Profit would also be very high up on its axis (at about 83% of its height). Glancing at the chart, it might look like Sales and Profit were almost equal, or that profit was unexpectedly high, even though sales were actually ten times larger.

This is where synchronizing becomes essential. By synchronizing the axes, you force both to use the exact same scale, providing an apples-to-apples visual comparison. That $5,000 Profit point would be shown at its true, much lower position relative to the $50,000 Sales point, giving stakeholders an honest view of performance.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Make a Dual-Axis Chart

Before you can synchronize an axis, you need to create a dual-axis chart. The process is straightforward. Let’s stick with our Sales and Profit example using the Sample - Superstore data in Tableau.

Step 1: Create a Basic Line Chart

First, create a simple visualization to act as your base.

• Drag the Order Date dimension to the Columns shelf. Right-click the pill and select the second "Month" option (the one with the year like May 2024), so you get a continuous timeline.
• Drag the Sales measure to the Rows shelf.

You now have a simple line chart showing sales over time.

Step 2: Add Your Second Measure

Next, bring your second metric into the view.

• Drag the Profit measure to the Rows shelf and place it to the right of the Sales pill.

This creates two separate line charts, stacked one on top of the other, occupying the same canvas. You'll notice each chart has its own Y-axis, but they are both on the left.

Step 3: Combine them into a Dual-Axis Chart

Here is where you combine the two charts. Find the new Profit pill you just added to the Rows shelf.

• Right-click the AGG(Profit) pill.
• Select Dual Axis from the context menu.

Tableau will immediately combine the two charts. You will now see two y-axes: one for Sales on the left and one for Profit on the right. You'll also notice the Marks card has changed, allowing you to control the properties of each measure independently.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Simple Click to Synchronize Your Axes

You’ve built your dual-axis chart, but if you look closely, the axes are scaled independently. The Sales axis on the left might run from $0K to $80K, while the Profit axis on the right runs from $0K to $15K. Now, let’s fix it.

Synchronizing the axes in Tableau is perhaps one of the easiest and most satisfying actions in the entire tool. It's truly a one-click fix.

• Right-click on either of the Y-axes in your chart. It doesn’t matter if it’s the left one or the right one. This brings up an options menu.
• Select "Synchronize Axis".

That's it. Tableau will instantly update the chart, forcing both axes to share the exact same range. For our Sales and Profit example, both axes might now run from $0K to $80K. Now you can clearly and accurately see the relationship between your totals. You can see how much smaller the profit values are compared to the sales values, even when profit trends upward.

When Not to Synchronize Axes

Synchronizing axes is powerful, but it's not always the right choice. It only makes sense when your two measures share the same unit and have a loosely similar scale. Comparing Sales dollars to Profit dollars? Synchronize.

But what if you're comparing Sales to Order Quantity?

Sales are measured in currency and can be in the hundreds of thousands. Order quantity is a unit-less count, and might be in the single or double digits for any given mark. If you were to synchronize these axes, the chart would be useless. The axis would need to scale large enough to accommodate the sales figures (e.g., $0 to $100,000), causing the order quantity line to be completely flattened against the bottom of the chart. Any variation in quantity - going from 5 to 15 - would be visually imperceptible.

The rule of thumb: Only synchronize axes when the units are the same (e.g., currency, percentages, counts) and you want a direct magnitude comparison. If you simply want to compare the trends or patterns of two measures with vastly different scales or units, an unsynchronized dual-axis chart is the appropriate choice.

• Good to Synchronize: Revenue vs. Costs, Number of New Customers vs. Number of Churned Customers, Website Goal Completions vs. Unique Visitors.
• Bad to Synchronize: Revenue ($) vs. Customer Satisfaction Score (1-5), Profit Ratio (%) vs. Number of Units Sold (count), Website Clicks (count) vs. Ad Spend ($).

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Common Troubleshooting Tip: When "Synchronize Axis" is Greyed Out

Sooner or later, you'll go to synchronize your axes, and you'll find the option is greyed out and unclickable. It’s a common frustration for new Tableau users, but the fix is usually simple.

The Problem: Tableau will not allow you to synchronize axes if the two measures have different data types.

The most common cause is having one measure as a floating-point number (e.g., Number (decimal)) and the other as a whole number (e.g., Number (whole)). For example, your Sales data might come in as a decimal, while Profit might be set as a whole number.

The Solution: You need to make the data types match.

1. Go to the Data pane on the left side of your screen.
2. Find the measure whose data type you want to change (in this scenario, let's say it's Profit).
3. Right-click on the Profit measure.
4. Go to Change Data Type.
5. Select the data type that matches your other measure. If Sales is a Number (decimal), then select Number (decimal) for Profit.

Once you've changed the data type, go back to your chart, right-click the axis again, and the "Synchronize Axis" option should now be available. After synchronizing, you can hide one of the axes by right-clicking it and unchecking "Show Header" to declutter your visualization, as displaying both is now redundant.

Final Thoughts

Applying a dual-axis chart in Tableau is an effective technique for data comparison, and synchronizing those axes is the single most important step for ensuring your chart is both visually clear and contextually honest. With just a simple right-click, you prevent stakeholders from drawing incorrect conclusions based on distorted visual scales, making your dashboards more trustworthy and effective.

We believe that getting this kind of clarity from your data shouldn't involve hunting through menus or getting tripped up by technical settings. Often, the questions you have are simple, like "show me website sessions versus sales over the last six months," and getting the answer should be just as simple. With Graphed, we’ve made that possible. You can connect your data sources in seconds and ask questions in plain English to instantly generate robust, live-updating dashboards, so you can focus on insights instead of configuration.