Create GeoMap Charts in Google Sheets

I’ve previously posted about charts in Google Sheets, but this post concerns one type of chart in particular that might be useful in certain special situations – the GeoMapA GeoMap is a chart showing the map of a country, continent, or other geographic region, painted with differing colours representing the spreadsheet cell values associated with the map’s locations.

Take a look at this little sheet:

Click image to enlarge

Click image to enlarge

I can highlight the range A1:B7 and select Insert > Chart… :

Click image to enlarge

Click image to enlarge

Now, from the Charts section of the Chart Editor, I select Maps and then click on my choice from two GeoMap styles:

Click image to enlarge

Click image to enlarge

From the Customise tab you can select your region to be displayed, change the colours used, and save your chart:

Click image to enlarge

Click image to enlarge

You may have to experiment a little to see what country and region names or abbreviations work correctly in recognising the location, though I imagine that (in addition to full names) all ISO country abbreviations will probably be OK, and the standard two-letter abbreviations for the US states.

The range of customisations is pretty limited (much more so than in the Google Charts API) but there might be occasions where it provides what you need to visualise your data with just a moment’s work.