If you want to create world map chart with markers by passing Latitude and Longitude of Location. Snapshot below -
Steps to use
To know more about it visithttps://developers.google.com/chart/interactive/docs/gallery/geochart
Download the working file https://www.box.com/s/hzbd6tc6l20sajj7zwel
- Download the file
- Go to “Data” sheet
- Add Latitude and Longitude of locations in Col A and B.
- Add the sales value in Col “C”. 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
No comments:
Post a Comment