To insert a map in Google Sheets, you can use the geo chart feature. Here's how to do it:
Your dataset should have at least two columns:
Column A: Geographic locations (e.g., countries, states, cities). Ensure these are spelled correctly for Google Sheets to recognize them.
Column B: Numeric data related to each location (e.g., population, GDP).
For this example, let's say we want to visualize the population of various countries. Your data might look something like this:
Click and drag to highlight both columns of your data, including the header row.
With your data selected, go to the menu, click on "Insert," and then select "Chart."
By default, Google Sheets will select a chart type for you. To change it to a geo chart:
1. Find the "Chart type" dropdown menu.
2. Scroll down and select either "Geo chart" for a colored map or "Geo chart with markers" if you prefer markers to represent your data points.
Below is what the geo chart should look like:
You can move or resize the chart as needed.
After selecting your chart type, you can customize its appearance:
Click on the "Customize" tab in the "Chart editor."
Here, you can adjust various settings like the chart's and labels' colors.
We hope that this article has helped you and given you a better understanding of how to make a map in Google Sheets. If you enjoyed this article, you might also like our articles on how to make a Pareto chart in Google Sheets and how to use the Google Sheets MAP function.
