Thursday, June 17, 2010

Chloropleth Maps in Excel

A colleague recently pointed me to a very cool example of creating a chloropleth map directly in Excel.

Wow. Just wow. And if you look at the map itself, you'll see that someone (apparently) meticulously drew out each province as a shape object. (Right-click one of them and you'll see the tell-tale "Edit Points" option.) The VBA written to make this work is also very succinct and simple to follow. Anyone seen one of these for the U.S.?

This is clearly the best example of mapping directly in Excel that I've ever seen. I thought you all might enjoy it as well.

That's all for now...