If you want to create country level heat map chart by passing Latitude and Longitude of its cities. Snapshot below-
To know more about it visit
Download working File
Steps to use
- Download the file
- Go to Data sheet
- Add Latitude and Longitude of locations in Col A and B.
- Add country code in cell F5
- 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
Post a Comment