Pages

Monday, November 19, 2012

Google Heat Map charts In Excel (at Country Level)


If you want to create heat map chart using Google Map charts in Excel. Snapshot below -
USA
India
Steps to use
  • Download any of the file
  • Go to “Data” sheet
  • Choose Country in cell “B2″. Make sure code appears in cell “C2″ . This code  tells Google map which country to display. List of codes is available here https://developers.google.com/chart/interactive/docs/gallery/geochart
  • Put the HTML code of minimum and maximum color in cell “F2″ and “F3″ . List of HTML code is easily available over net or you can pick it from here http://www.w3schools.com/tags/ref_colornames.asp
  • Add the state names and the value in Col “A” and “B” from row 7 onwards .
  • You can change the header of Sales column to “Population” ,”Market Share” , etc as per your requirement . Make sure you do not change “State”. It should be spelled as state only
  • Once you add the state names and sales . Click on Update map button. Make sure spell of state mentioned should be correct else it will display error
Note (before you run the update map macro)
You can create the same map for any region / country all you need is Country code which is available  at the above link and correct spelling of States.

No comments:

Post a Comment