If you want to create heat map chart using Google Map charts in Excel. Snapshot below -
USA
India
India working file https://www.box.com/s/cweh4kp00wc6o8cocnai
USA working file https://www.box.com/s/kh97q5u8dqb0wliollnz
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 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
- 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
You can create the same map for any region / country all you need is Country code which is available at the above link and correct spelling of States.
To know more about it visit https://developers.google.com/chart/interactive/docs/gallery/geochart
No comments:
Post a Comment