Make a Pictogram in Excel

Make a Pictogram in Excel

This graph type goes by a lot of names: isotype chart, pictograph, or pictogram. Whichever way, it allows us to use symbols rather than stick with the squares that make up the waffle chart. And it is especially well suited to representing small counts of things that...
First, Sketch.

First, Sketch.

Some might claim they look at a blank PowerPoint slide and see a source of hope and possibility, similar to how artists supposedly see inspiration in a blank canvas. I call bullshit on this. Artists did not just walk up to a blank canvas and envision their end...
Most Diagrams Suck

Most Diagrams Suck

Here’s how to make them more effective. Diagrams come in many different flavors – mind maps, concept maps, flow charts, and so on – but at the core, they are all visualizations of how themes relate to one another. As ubiquitous as diagrams are, they have some...
Ever Heard of a Dendrogram?

Ever Heard of a Dendrogram?

When Jenny Lyons and I were pulling together the revised chapter on Qualitative Visualization in Effective Data Visualization, 2nd edition, we ended up ditching this section on dendrograms. In the list of most-likely-to-use qualitative visuals, this one is probably...
Pre-Work Checklists

Pre-Work Checklists

I have learned all of these lessons the hard way. I now have two checklists I run through before I have a workshop. One handles logistics and it’ll only be useful if you also run workshops. The other helps me determine whether a potential client and I are a good...
No Unnecessary Lines

No Unnecessary Lines

The Lines section of the Data Visualization Checklist helps us enhance reader interpretability by handling a lot of the junk, or what Edward Tufte called the “noise” in the graph. I’m referring to all of the parts of the graph that don’t...
Intentionally Order Your Data

Intentionally Order Your Data

Listen, no one cares about the order we listed the response options on the survey. But most graphs, especially those automatically generated from survey software, showcase the data in that order. And that isn’t useful for anyone trying to interpret the data....
2019 Call for Mentees

2019 Call for Mentees

Did you see Vice? There’s a scene (this is no spoiler) in which a young Dick Cheney and Antonin Scalia share a sickening laugh as they agree to an interpretation of the Constitution that allowed a massive power grab for a president. It’s gross. It’s...