Visualising geographic distributions, regional sales performance, country-level customer acquisition, and international supply chains requires specialized mapping capabilities. While standard bar charts rank countries alphabetically or by revenue magnitude, they fail to reveal spatial clustering and regional geographic trends. Google Sheets includes native Geo chart visualisations that parse country names, ISO country codes, states, and coordinates to render interactive choropleth heatmaps and marker maps.
Understanding Geo Charts in Google Sheets
Google Sheets offers two distinct Geo chart display modes:
- Regions Mode (Choropleth): Fills entire geographic entities (countries, provinces, or states) with colour gradients proportional to numeric data values. Best for demographic indicators, regional revenue, and market penetration analysis.
- Markers Mode: Plots discrete circular bubbles over specific cities, addresses, or latitude/longitude coordinates. Marker size and colour correspond to numeric metrics, ideal for pinpointing regional office hubs or retail storefronts.
Structuring Geographic Data in Sheets
To ensure Google Sheets accurately maps your locations without geographic ambiguity, structure your dataset with clean location headers:
| Region / Country | Revenue (£) | Customer Count |
|---|---|---|
| United Kingdom | 450,000 | 1,240 |
| Germany | 380,000 | 980 |
| France | 290,000 | 810 |
| Netherlands | 210,000 | 640 |
Tip: You can use full country names (e.g., United Kingdom) or standard two-letter ISO 3166-1 alpha-2 codes (e.g., GB, DE, FR, NL).
Step-by-Step: Creating a Geo Chart
- Highlight your geographic data range (e.g., cells
A1:C5). - Navigate to the top menu bar and select Insert > Chart.
- In the Chart editor sidebar on the right, ensure the Setup tab is active.
- Click the Chart type dropdown, scroll down to the Map category, and choose Geo chart (or Geo chart with markers).
- Google Sheets renders the geographic map on your canvas.
Scoping the Geographic Region and Focus
By default, Geo charts display a world map. If your data focuses exclusively on a single continent or sub-region, zoom the chart view:
- In the Chart editor sidebar, switch to the Customise tab.
- Expand the Geo section.
- Locate the Region dropdown.
- Select your target scope:
- World: Global international footprint.
- Europe / Asia / Americas / Africa / Oceania: Continental aggregates.
- Specific Sub-regions: Focuses specifically on Northern Europe, Western Europe, or US States.
- Observe how the map canvas crops cleanly to your selected region, eliminating empty ocean space and improving visual legibility.
Customising Colour Gradients for Data Density
Calibrating heat map colour ramps ensures intuitive interpretation:
- In the Customise > Geo pane, locate the colour swatches:
- Min colour: Set to a light shade (e.g., pale blue or grey) representing low values.
- Mid colour: (Optional) Sets an intermediate baseline tint.
- Max colour: Set to a bold, saturated hue (e.g., deep navy or emerald green) representing high performance.
- No value: Defines how countries with no recorded data are painted (light grey is standard).
- Hover over individual territories on the map to test the interactive tooltip displaying country names and exact numeric values.
Embedding Maps into Dashboards
Geo charts are fully responsive. You can resize the chart container, move it into dedicated reporting sheets, or publish it as an interactive web widget via File > Share > Publish to web for inclusion in live client portals.