How to Use Geo Chart in Google Sheets: A Comprehensive Guide

Published: December 17, 2023 - 3 min read

Hannah Recker

Geo charts in Google Sheets provide a powerful visual representation of geographical data. They allow users to transform data sets into interactive maps with markers, color-coding, and customizable options.

By using geo charts, people can reveal patterns and trends hidden within the data, making it easier to understand and analyze.

In this article, we will walk you through the process of creating and customizing geo charts in Google Sheets. We will demonstrate how to organize data effectively, insert the chart, and make adjustments to enhance the visual aspect and overall functionality of your geo chart.

Understanding Geo Charts

Purpose of Geo Charts

Geo charts are invaluable for visualizing key business metrics across different regions. For instance, they can illustrate regional sales trends, customer density, or market share, providing a quick snapshot of business performance.

Key Components of Geo Charts

There are two main types of geo charts in Google Sheets: Region mode and Markers mode.

  1. Region mode: This mode colors entire regions, such as countries, provinces, or states. It is useful when you want to highlight data for specific areas.

Example Region mode:



United States






  1. Markers mode: In this mode, circular markers are used to display data for specific locations. The marker size is based on the data for each location. Markers mode can be helpful when presenting data for cities or specific points on a map.

Example Markers mode:


CO2 (tonnes)

New York


Los Angeles



spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.


Using Geo Charts in Google Sheets

Data Preparation

Before creating a geo chart, it’s essential to prepare the data accurately. The data should be organized in a table format with at least two columns.

The first column should contain geographical data (like country, region, or city names), and the second column should contain values (such as population or sales figures).

Sample data table showing business metrics for geo chart in Google Sheets.

File Name: business-operations-data-table.png

Alt Text: Sample data table showing business metrics for geo chart in Google Sheets.

Creating a Geo Chart

Once the data is prepared, follow these steps to create a geo chart:

  1. Select the data range, including column headers.
Highlighting the data range in Google Sheets for a geo chart.

Click on Insert in the menu, and then select Chart.

Accessing the 'Insert Chart' option in Google Sheets.

By default, Google Sheets might generate a different type of chart.

To change it to a geo chart, click on the Chart type dropdown in the Chart editor panel and select Geo chart or Geo chart with markers. The map will be generated automatically and displayed on your sheet.

Changing the chart type to Geo chart in Google Sheets

Customizing the Geo Chart

To customize the appearance and settings of the geo chart, use the Customize tab in the Chart editor panel. Some available options include:

  • Chart Style: Opt for professional color schemes.
  • Geo: Focus on regions relevant to your business.
  • Color Axis: Set colors to reflect thresholds, like sales targets.
Customized geo chart reflecting business metrics in Google Sheets.


Geo charts in Google Sheets are a powerful tool for visualizing and understanding business data geographically. By following these steps and tips, you can create insightful geo charts tailored to your business needs.

Ready to transform your business data into actionable insights? Install Coefficient now and elevate your data analysis in Google Sheets.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies