The Easiest Way to Make Bullet Charts in Excel

There are lots of ways to make bullet charts, some easier than others, some better suited for specific visualization contexts. Hell, there are plug-ins you can purchase that make it a snap. Except when my plug-in broke and I had to remake about a…

Read More

Adding a Benchmark Line to a Graph

This simple line packs so much power. Adding a benchmark line to a graph gives loads of context for the viewer. Here’s how to make one right inside Excel. It’s so easy you might pass out. My data table looks like this: I have my data and I have the benchmark…

Read More

An Incomplete List of Females in Data Visualization

I rewrote this post 4 times, in an effort to give it a calm and professional tone. And then I thought “Ah fuck it, this is my blog and I can say whatever I want.” I’m writing this post because I just listened to an interview about data visualization. It…

Read More

Who Can Do Dataviz (or How a Field Evolves)

Wow, the action in the dataviz/tech world this past week has been awesome! A female programmer at a Python (that’s a programming language also used for dataviz) conference was fired after tweeting about the sexist jokes she was hearing from a largely white young male crowd, and Tableau’s…

Read More

Before & After Slides: Stay on the Side of Simplicity

My friend, Kurt Wilson, and I just wrapped up a contract to revise a set of slides – and the graphs within – for a big international client I can’t name. Here I’ll walk through one of the original slides and our revision of it. Keep in mind that these…

Read More

Making Back-to-Back Graphs in Excel

Let’s say we’re interested in comparing how two groups – oh, teachers and principals – responded to a survey. One way to visually display that comparison would be a bar graph, where each question had two bars, one for teachers and one for principals. It’s helpful in some ways, but…

Read More