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

I love 3D bar charts

OK, maybe “love” is too strong a word. Let’s say that 3D column/bar charts are like a tall and ugly building: better appreciated from the top, where you can’t see it but you can enjoy a great view. Like this: Now, change the viewing angle, remove gaps and you get this: I’m shamelessly copying the … Read more

The best of two worlds: the scatterplot pie

The best chart is always task-dependent, but let me assume that you would choose the scatterplot as the best chart and the pie as the worst. They are like water and oil: impossible to mix them! Are they? Let me tell you about a little experiment. I call it the scatterplot pie just for fun, … 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