At-a-Glance Patterns with Area Charts

A few weeks ago I showed you how to create small multiples bar charts simply by creating a stacked bar chart in Excel with invisible white segments. In 5 minutes or less! Today’s strategy to use area charts takes a few minutes longer, but the result is worth it.
More »

From Data Table to Small Multiples in Under Five Minutes

When social scientists like me have lots of data, we tend to put it in tables. There’s nothing wrong with tables. They contain infinite details within a finite and teeny space, and they give the reader freedom to draw his or her own conclusions about which details are worth paying attention to. Today I’m teaching you to take your data table and turn into a small multiples chart in under five minutes.
More »

=vlookup(): One Excel function to rule them all

I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining datasets, like when you’ve got program participants’ demographic data in one place and their scores or outcomes in another place. 
More »