Making Excel maps without VBA

If you want to make a choropleth/thematic map in Excel without programming perhaps conditional formatting is all you need. Here is how to do it: Select a few hundred columns and rows; Set width and height to 3 (more or less, depending on the resolutions you want); Set font size to 1; Place a map … Read more

Animation, Small Multiples or the Reorderable Matrix? Growth of Walmart, Excel Edition

In data visualization, animation is overrated. OK, it’s an interesting option if you can see a clear pattern emerging when displaying data over time/space (and, thanks to animation, we were introduced to this communicator extraordinaire named Hans Rosling). It’s fun to make an animated GIF like the one above, but you must see animation as … Read more

Making maps in Excel: cross-stitching edition

County map Excel

There are several objects in Excel you can make a map with. If you want to use shapes, you can follow my tutorial. You can also use a scatter plot. The map above uses cells and conditional formatting. So, here is how to do it (this example used population data): Get a table from the US Census … Read more

The same data, the same map, different stories

Thematic map us states poverty percentage same number of states

Choropleth maps are the pie charts of cartography. Both can show us a simple pattern, but that’s a very low starting point. And both have severe perceptual issues. One of the issues with maps is how to define classes. Gregor published last Friday an interesting post and I wanted to play with the same data, percentage of … Read more

Geo-scatterplot or the poor man’s GIS

This is an Excel scatterplot. Each point is one of the 4200 Portuguese civil parishes. The green point shows the active parish and the red ones some parishes that may have a similar profile. Of course, if you select a different parish the red set also changes. I like this idea of displaying geographic coordinates … Read more