If you want to create heat map chart using Google Map charts in Excel at city level. Snapshot below -
Download working File here https://www.box.com/s/ythhetfu26if1dtuamsq
To know more about it visit https://developers.google.com/chart/interactive/docs/gallery/geochart
Steps to use
- Download the file
- Go to “Data” sheet
- Choose Country in cell “B2″. Make sure code appears in cell “C2″ . This code is tells Google map which country to show in the map. 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 city names and sales values in Col “A” and “B” 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 “City”. It should be spelled as city only
- Click on Update map button. Make sure spell of cities mentioned should be correct else it will display error
To know more about it visit https://developers.google.com/chart/interactive/docs/gallery/geochart
No comments:
Post a Comment