Pages

Monday, November 19, 2012

Google Heat Map charts In Excel (at City Level)


If you want to create heat map chart using Google Map charts in Excel at city level. Snapshot below -
Download working File here https://www.box.com/s/ythhetfu26if1dtuamsq
Steps to use
  • Download the file
  • Go to “Data” sheet
  • Choose Country in cell “B2″. Make sure code appears in cell “C2″ . This code is tells Google map which country to show in the map. 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 city names and sales values in Col “A” and “B” 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 “City”. It should be spelled as city only
  • Click on Update map button. Make sure spell of cities mentioned should be correct else it will display error

No comments:

Post a Comment