Synchronizing axes in Tableau - Cell-by-Cell Formula Trace

Sample Data

Monthly sales and profit data for a small business

Cell	Value
A1	Month
B1	Sales
C1	Profit
A2	Jan
B2	1000
C2	200
A3	Feb
B3	1500
C3	300
A4	Mar
B4	1200
C4	250
A5	Apr
B5	1700
C5	400

Formula Trace

Synchronize axes for Sales and Profit in a dual-axis chart

Step 1: Identify Sales axis range: MIN=1000, MAX=1700

Step 2: Identify Profit axis range: MIN=200, MAX=400

Step 3: Set both axes to common range: MIN=0, MAX=1700

Step 4: Adjust Profit values visually to match Sales scale

Step 5: Result: Dual-axis chart with synchronized axes

Cell Reference Map

     A       B       C  
1  Month   Sales   Profit
2   Jan    1000     200 
3   Feb    1500     300 
4   Mar    1200     250 
5   Apr    1700     400 

Arrows: Sales (B2:B5) and Profit (C2:C5) feed into dual-axis chart

Sales and Profit columns are the data sources for the synchronized dual-axis chart

Result

Month | Sales (left axis) | Profit (right axis)
---------------------------------------------
 Jan  | 1000  | *           | 200  | *        
 Feb  | 1500  | **          | 300  | **       
 Mar  | 1200  | *           | 250  | *        
 Apr  | 1700  | ***         | 400  | **       

Axes synchronized from 0 to 1700 for both Sales and Profit

The chart shows Sales and Profit bars aligned on the same scale, making it easy to compare trends

Sheet Trace Quiz - 3 Questions

Why do we set both axes to the same range when synchronizing?

A To make the measures directly comparable on the same scale

B To hide the smaller values

C To make the chart colorful

D To separate the measures visually

Key Result

Synchronizing axes sets both measures to a common scale for direct comparison in dual-axis charts