Pages

Monday, November 19, 2012

Google World Heat Map chart in Excel

If you want to create world heat map chart using Google Map charts in Excel. Snapshot below -
Image
Steps to use
  • Download the file
  • Go to “Data” sheet
  • Add country names or ISO code of country in col A. Make sure do not rename header of col “A” (Country)
  • Add the sales value in Col “B”. You can change the header of Sales column to “Population” ,”Market Share” , etc as per your requirement .
  • 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
  • Click on “update map” button
Note

No comments:

Post a Comment