Over the past year I've been having a play mapping things in Excel, not the best tool for doing this I know but it does the trick. Mapping the data directly from Excel has the advantage that I've my data is already in Excel. I would like to do the same exercise in R but that's for another day once I get to know R better.
The method I used is based on tips and methods used on Chandoo and Clear and Simply.
My output looks like this:
Which looks pretty good to me.
It has a number of features:
- Choropleth map based on postcode area
- Mouse over each area to find out it's name and value
- A data table showing the values for a clicked on area compared to the overall total
- A dropdown box so you can choose what variable you want to map
- Fully customisable list of colours for the map and a few pre-defined colour sets
- The legend automatically adjusts to your data, but if it doesn't you can overide the values
There may be other features but they are the main ones.
The spreadsheet containing this map is here.
Hopefully I'll explain it a bit more about how it works another day.
Download Mapping UK Postcode Areas
Hi Richard, I've just come across your webpage about Choropleth map based on postcode area which is exactly what I'm trying to put together. Unfortunately the link to the map doesn't seem to lead anywhere..
I would be very much grateful if there was any way at all for you to share it?
https://drive.google.com/open?id=0B3W3sjJMD2ARSVRucDkwaE5MMEk&authuser=0
many many thanks
Francesco
Hi Francesco, I have updated the link now so it should work now. Please let me know if you have any feedback about the spreadsheet.
I have also added a new post which contains a newer version of this spreadsheet with some enhanced features.
Sorry for the delay in getting back to you.
Richard