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 GeoMap. A 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:
I can highlight the range A1:B7 and select Insert > Chart… :
Now, from the Charts section of the Chart Editor, I select Maps and then click on my choice from two GeoMap styles:
From the Customise tab you can select your region to be displayed, change the colours used, and save your chart:
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.