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-

Download Working File https://www.box.com/s/6ooa51o1cw164q2yhi0v 

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

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