KNOWLEDGE BASE

How To Synchronize Axis Across Multiple Worksheets Without Using Fixed Range


Published: 22 Apr 2021
Last Modified Date: 22 Apr 2021

Question

How to synchronize axis across multiple worksheets without using fixed range

Environment

  • Tableau Desktop

Answer

Sheet1:
User-added image
Sheet2:
User-added image

For Sheet1:
1. Drag [Profit] to Detail
2. Right click on the Sales axis > Add Reference Line
3. Configure:
-Scope: Per Cell
-Line: 
 Value: SUM(Profit)
 Label: None
 Tooltip: None
-Formatting
 Line: None
 Fill Above: None
 Fill Below: None
Uncheck "Show recalculated line..."
4. Click OK

For Sheet2:
1. Drag [Sales] to Detail
2. Right click on the Profit axis > Add Reference Line
3. Configure:
-Scope: Per Cell
-Line: 
 Value: SUM(Sales)
 Label: None
 Tooltip: None
-Formatting
 Line: None
 Fill Above: None
 Fill Below: None
Uncheck "Show recalculated line..."
4. Click OK

User-added image
Did this article resolve the issue?