Pages

Monday, November 19, 2012

Google World Map chart with markers in Excel


If you want to create world map chart with markers using Google Map charts in Excel. Snapshot below -
Image
Download working file here https://www.box.com/s/jy6w38my7hwgum3sw04s
  • Download the file
  • Go to “Data” sheet
  • Add country names or ISO code of country in col A. Make sure do not rename header of col “A” (Country)
  • Add the sales value in Col “B”. You can change the header of Sales column to “Population” ,”Market Share” , etc as per your requirement .
  • Put the HTML code of minimum and maximum color in cell “F2″ and “F3″ . List of HTML code is easily available over net or you can pick it from here http://www.w3schools.com/tags/ref_colornames.asp
  • Click on “update map” button
Note

No comments:

Post a Comment