Geo charts and maps in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Sales data by country used to create a Geo chart showing sales distribution on a map.

Cell	Value
A1	Country
B1	Sales
A2	USA
B2	1000
A3	Canada
B3	700
A4	Mexico
B4	400
A5	Brazil
B5	600

Formula Trace

GEO_MAP(A2:B5)

Step 1: A2:B5

Step 2: GEO_MAP([["USA", 1000], ["Canada", 700], ["Mexico", 400], ["Brazil", 600]])

Cell Reference Map

    A       B
1 Country  Sales
2  USA     1000  <-- Used for country name and sales value
3  Canada   700  <-- Used for country name and sales value
4  Mexico   400  <-- Used for country name and sales value
5  Brazil   600  <-- Used for country name and sales value

The formula references the range A2:B5 which contains country names and their sales numbers.

Result

[Geo Chart Map]
Countries colored from darkest (USA) to lightest (Mexico) based on sales values:
- USA: darkest color (1000 sales)
- Canada: medium dark (700 sales)
- Brazil: medium light (600 sales)
- Mexico: lightest color (400 sales)

The Geo chart visually shows sales distribution by coloring each country on the map according to its sales value.

Sheet Trace Quiz - 3 Questions

What does the range A2:B5 represent in the GEO_MAP formula?

A Country names and their sales values

B Only sales values

C Only country names

D Random numbers

Key Result

GEO_MAP(range) creates a map coloring regions based on numeric values in the range.