Dual-axis maps in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample data showing cities with their latitude, longitude, sales, and profit values used for creating dual-axis maps in Tableau.

Cell	Value
A1	City
B1	Latitude
C1	Longitude
D1	Sales
E1	Profit
A2	New York
B2	40.7128
C2	-74.006
D2	100000
E2	20000
A3	Los Angeles
B3	34.0522
C3	-118.2437
D3	85000
E3	15000
A4	Chicago
B4	41.8781
C4	-87.6298
D4	60000
E4	12000

Formula Trace

Dual-axis map layers: Layer 1 = Map with city locations (Latitude, Longitude), Layer 2 = Circle marks sized by Sales and colored by Profit

Step 1: Plot points using Latitude and Longitude for each city

Step 2: Create first axis with map background and city points

Step 3: Create second axis with circle marks sized by Sales

Step 4: Color circles by Profit values

Step 5: Synchronize axes and overlay second axis on first

Cell Reference Map

    A          B          C          D          E
1 | City     | Latitude | Longitude | Sales    | Profit   |
2 | New York | 40.7128  | -74.0060 | 100000   | 20000    |
3 | Los Angeles | 34.0522  | -118.2437| 85000    | 15000    |
4 | Chicago  | 41.8781  | -87.6298 | 60000    | 12000    |

References:
- Latitude (B2:B4) and Longitude (C2:C4) for map points
- Sales (D2:D4) for circle sizes
- Profit (E2:E4) for circle colors

This map shows which columns are used for plotting city locations and which columns control circle size and color in the dual-axis map.

Result

    A          B          C          D          E          F
1 | City     | Latitude | Longitude | Sales    | Profit   | Map Output
2 | New York | 40.7128  | -74.0060 | 100000   | 20000    | ●●●●● (large, bright)
3 | Los Angeles | 34.0522  | -118.2437| 85000    | 15000    | ●●● (medium, medium bright)
4 | Chicago  | 41.8781  | -87.6298 | 60000    | 12000    | ●● (small, less bright)

Legend:
- Circle size ~ Sales
- Circle color brightness ~ Profit

The final dual-axis map shows city points with circles sized by sales and colored by profit, layered on the same geographic map.

Sheet Trace Quiz - 3 Questions

Which columns provide the geographic location for the city points on the map?

A Sales and Profit

B Latitude and Longitude

C City and Sales

D Profit and Latitude

Key Result

Dual-axis maps overlay two map layers sharing the same geographic scale, combining location points with sized and colored marks.