Tuesday, June 22, 2021

Create a Geo Map Chart - Google Sheets

If you've got data to map, you might want to using the geo chart maps in Google Sheets. As long as you have some type of value that can be mapped like city, state or country, you can assign colors or markers to your data on a geographic map. All you need are two columns; one for the locale and the other to represent some quantitative value. The catch is that there are just to geo map options to use in Google sheets. Also you can't map latitude and longitude. However there is a workaround to that which involves some script (don't worry it's a copy/paste) and later on I'll even so you how to incorporate google sheet data with the google maps application.

No comments:

Post a Comment