Geo charts and maps in Google Sheets - Dashboard Guide

Dashboard Mode - Geo charts and maps

Goal

Show sales performance by country on a map to quickly see which countries have higher or lower sales.

Sample Data

Country	Sales
United States	1500
Canada	800
Brazil	600
United Kingdom	1200
Germany	1100
India	900
Australia	700

Dashboard Components

• Total Sales (KPI Card): Shows total sales across all countries.
  Formula: =SUM(B2:B8)
  Result: 6800
• Average Sales per Country (KPI Card): Shows average sales.
  Formula: =AVERAGE(B2:B8)
  Result: 971.43
• Geo Chart: Displays sales by country on a world map.
  Data range: A1:B8
  Chart type: Geo chart (Insert > Chart > Chart type: Geo chart)
  Shows countries colored by sales amount, darker color means higher sales.
• Sales Table: Shows the raw data for reference.
  Range: A1:B8

Dashboard Layout

+----------------------+----------------------+
| Total Sales: 6800    | Average Sales: 971.43|
+----------------------+----------------------+
|                      Geo Chart               |
|                                              |
|                                              |
+----------------------------------------------+
|               Sales Data Table                |
+----------------------------------------------+

Interactivity

Add a filter dropdown for Country. When you select a country, the Geo Chart, Total Sales, Average Sales, and Sales Table update to show data only for that country.

This helps focus on one country's sales performance quickly.

Self Check

If you add a filter for Country = Germany, which components update?

• Total Sales shows 1100
• Average Sales shows 1100
• Geo Chart highlights Germany only
• Sales Table shows only the Germany row

Key Result

A dashboard showing total and average sales by country with a Geo Chart map and data table.