![]()
How do you create a map like the one above for your next presentation if you don’t have a mapping tool? Simple, create it in Excel. Easier said than done, right? Well, not really…
Following the “geo-scatterplot”, in this screencast tutorial I’ll show you how to create a thematic map and color-code it, based on your own data. You don’t need add-ins or additional software, just a little time to set it up. Please note that this is not intended to replace even the simplest mapping tool.
To start the tutorial just click the link below:
Screencast: How to create a thematic map in Excel.
Note that you need a map. You can draw it yourself or you can import it. Drawing a States map is simple:
- Import an image to the Excel file (you can use this one, for example);
- Draw the shapes using the map as a reference.
The other option is to obtain a file. You can get an ESRI Shape file from the National Atlas but you’ll have to convert it to Windows Metafile (WMF) or similar format.
Hope you’ll find this technique useful and feel free to suggest any improvements.
If you liked this tutorial you may be interested in How to create population pyramids and the “Howto Edition” fo the Demographic Dashboard. And you may consider subscribing…
You may also be interested in:

{ 2 trackbacks }
{ 59 comments… read them below or add one }
← Previous Comments
Jaws: I think that’s one of the “features” in Excel 2007: it doesn’t record most changes in charts and shapes. I’ll try to create an “Excel 2007 – friendly” version.
yeah.. how does it work with excel 2007?
thanks a lot!
I’m making a 2007 version. It will be available soon.
Wow! Thanks!!! I knew Excel could do this. I have been looking for this for more than ten years now. I will be sure to look at the rest of your site, Jorge.
Never mind.
Took me some time, but this is my solution:
Selection.ShapeRange.Fill.ForeColor.SchemeColor = Range(Range(“actRGScode”).Value).Interior.ColorIndex + 7
Now it works with costum palette
Hi, Very interesting, your mapping tool for excel data. But it seems not so easy for us. But, could you do some work for us and provide us a Chart of Luxemburg with the county boundaries (comunas). We could of course provide your with the official graphs that are available.
Can your make us an offer for such a job?
Muito obrigado pela sua ajuda.
M. SIMONIS
Great map idea!!!
I had it done for Europe and works!!!! My data is in %.. do you know how can show this data onthe righ position in the map with the right format…
Great stuff and thanks for sharing your knowledge
Please is there any software converit PNG picture to re-colour WMF
any1 knows how to make PNG like those fillable pieces in the US map
← Previous Comments