Excel VBA Codebase: Google Map

Showing posts with label Google Map. Show all posts

Saturday, December 8, 2012

If you want to create world map using Google Geo Chart Maps and choose your own colors to specify the countries. Snapshot below -

Download working File https://www.box.com/s/yxur2ea2r7cswct80hdz

Steps to use

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 the country names or ISO code of that country in column A from row 2 onwards

Add text to be displayed in Tool Tip in Col C

Click on Update Map

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

India Map

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

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

If you want to show/plot your office location/delivery centers on Google World Map. Snapshot below-

Steps to Run

Download the file
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
Click on Update Macro
Update the Legend on “Map” sheet manually