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 -
Download working file here
  • 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
  • Click on “update map” button

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...