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
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
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
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
How do you create a thematic 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… You know that you can add shapes to your worksheet, don’t you? So, why not to add shapes that mirror … Read more
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
