Pages

Friday, November 30, 2012

Google World Heat Map (By Passing Latitude and Longitude)


If you want to create world map chart with markers by passing Latitude and Longitude of Location. Snapshot below -
Image
Steps to use
Download the working file https://www.box.com/s/hzbd6tc6l20sajj7zwel
  • Download the file
  • Go to “Data” sheet
  • Add Latitude and Longitude of locations in Col A and B.
  • Add the sales value in Col “C”. 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

No comments:

Post a Comment