chirayu
Well-Known Member
Hi All,
In terms of creating Choropleths I am a complete novice. For those of you who don't know what a Choropleth is, its basically a Geographical representation of data (as I understand it). What that means is that you create a map that changes basis the data you input, e.g. location wise colour changes.
I wanted to share a tutorial link for this because through the screencast on the below website, I was able to create my own sample for India (albeit that its useless for the company I'm in because we don't have that many centres in India, but still - good practice)
http://www.excelcharts.com/blog/how-to-create-thematic-map-excel/
I have attached my sample version so u can check it out - its pretty lame because not that many data points used. You can get free WMF maps from the D-Maps website.
Edit by Hui: Please use the worksheet password: coetrg1
In terms of creating Choropleths I am a complete novice. For those of you who don't know what a Choropleth is, its basically a Geographical representation of data (as I understand it). What that means is that you create a map that changes basis the data you input, e.g. location wise colour changes.
I wanted to share a tutorial link for this because through the screencast on the below website, I was able to create my own sample for India (albeit that its useless for the company I'm in because we don't have that many centres in India, but still - good practice)
http://www.excelcharts.com/blog/how-to-create-thematic-map-excel/
I have attached my sample version so u can check it out - its pretty lame because not that many data points used. You can get free WMF maps from the D-Maps website.
Edit by Hui: Please use the worksheet password: coetrg1
Attachments
Last edited by a moderator: