Saturday, December 1, 2012

Plot locations on Google Chart map by passing Latitude and Longitude (Country Level)

If you want to show/plot your office location/delivery centers on Google Chart Map. Snapshot below-
Steps to Run
  • Download the file
  • Go to Data sheet
  • Add color codes and Html name of color in Col  F & G(Make sure Color codes are in ascending order like 1 , 2, 3 etc and are in numbers only)
  • Add Latitude and Longitude in Col A & B
  • Add color code in Col C
  • Add text to be displayed in Tool Tip in Col D
  • Choose Map Code in cell J2 from the list below
  • Click on Update Macro
  • Update the Legend on “Map” sheet manually

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...