Geo charts

Use a geo chart to show a map of a country, continent or region. The values for each location are shown with colours. For example, create a map that shows the population of countries in Europe.

Learn how to add and edit a chart.

How to format your data

  • First column: Enter location names or region codes.
  • Second column: Enter numerical data. You can also add a category name (optional).
  • Rows: Each row represents a different location on the chart. You can also add a category name to the rows, instead of the columns (optional).

Examples

Sales per country
Region Sales
United States £3,500,000
England £2,200,000
Australia £1,700,000
Germany £2,700,000

 

Geo chart showing sales by country

Make a copy

Coffee production
Country Coffee production
Brazil 30%
Vietnam 20%
Colombia 20%
Indonesia 15%
Ethiopia 10%
India 5%

 

A geo chart showing coffee production

Make a copy

Other types of geo charts

Geo chart with markers

Use a geo chart with markers when you want to show data for a location using a circular marker. The marker size is based on the data for each location.

Learn how to add and edit a chart.

How to format your data

Example

Internet usage

Country Internet usage
United States 30%
Germany 25%
France 20%
Taiwan 10%
Netherlands 5%
United Kingdom 10%

 

Geo chart showing Internet usage

Make a copy

Customise a geo chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart that you want to change.
  3. At the right, click Customise.
  4. Choose an option:
    • Chart style: Change background colour or font.
    • Geo: Choose a region or change location colours.

Related articles

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
15111598519918369948
true
Search Help Centre
true
true
true
true
true
35
false
false