Google Marker Map charts In Excel (at Country Level)

If you want to create country level map chart with markers using Google Map in Excel. Snapshot below -

India

USA

Download working file India https://www.box.com/s/ksyg0k4wt6600hmnuzsu

Download Working file USA https://www.box.com/s/kf4ex5yyw254clvo9t9v

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

Steps to use

• Download any of the file
• Go to “Data” sheet
• Choose Country in cell “B2″. Make sure code appears in cell “C2″ . This code tells Google map which country to display . List of codes is available here https://developers.google.com/chart/interactive/docs/gallery/geochart
• Put the HTML code of minimum and maximum color for markers in cell “F2″ and “F3″ . List of HTML code is easily available over net or you can pick it from here http://cloford.com/resources/colours/500col.htm
• Add the state names and the value in Col “A” and “B” from row 7 onwards .
• You can change the header of Sales column to “Population” ,”Market Share” , etc as per your requirement . Make sure you do not change “State”. It should be spelled as state only
• Once you add the state names and sales . Click on Update map button. Make sure spell of state mentioned should be correct else it will display error

Note (before you run the update map macro)

• Check the spelling of state names
• Check the Country code .List of codes is available here https://developers.google.com/chart/interactive/docs/gallery/geochart