Saturday, December 8, 2012

Create a country/Region Level Map Using Google Geo charts


If you want to create country level map using Google map and choose your own colors to specify the states/locations. Snapshot below -
USA Map
Image
India Map
Image


Steps to use 
  • Download any of the file
  • Go to Data Sheet
  • Add country code in cell J2 from list https://developers.google.com/chart/interactive/docs/gallery/geochart
  • 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 the State names in column A from row 2 onwards
  • Add text to be displayed in Tool Tip in Col C
  • Click on Update Map

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