Friday, November 30, 2012

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-

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
  • Click on “update map” button

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...