Create a choropleth map in Google Sheets

Creating an interactive choropleth map in Google Sheets is incredibly easy. I’ve put together this guide to help you through the process.

You first need to open a Google Sheet and enter a list of countries you want to include in your map. Use our Google Sheet containing a list of countries and paste it into your sheet to save time.

Next, enter the data you want to present on your choropleth map. In the example below I’ve added some mock data for demonstration purposes only.

Once you have input your data highlight it then go to Insert > Chart

A graph will be inserted. Don’t worry, it always does this. Next, scroll down the Chart Editor and select Map.

The choropleth map will now be displayed. In this example, data is only presented for selective countries as I have only input a small amount of data.

You can customise the map by pressing the Customize tab in the right-hand pane. You can change the region to continents and the colour scheme.

If you hover your cursor over a country it will display its name and value.

If you have a website you can embed a map into a page very easily. To do this click the three dots in the top right corner of your map. Then select Publish Chart.

Next, you need to click the Publish button once you are happy with the settings.

Finally, copy the code and embed it in your website.

If you need a quick and easy way to make a choropleth map then Google Sheets is the answer!

If you are looking to further the develop the use of Google Apps in your classroom or school our friends over at Cre8tiveIt.solutions can provide support and training with the use of Google Suite, Google Drive, Google Edu and Google Classroom.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.