Google Country Level Heat Map (By Passing Latitude and Longitude)

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
https://developers.google.com/chart/interactive/docs/gallery/geochart

Download working File 

https://www.box.com/s/6ooa51o1cw164q2yhi0v

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

Share this: