Plot locations on Google World map by passing Latitude and Longitude

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

Download Working File https://www.box.com/s/jmiszmh8skms52i0a6b6

To know more about it visit
https://developers.google.com/chart/interactive/docs/gallery/geochart

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