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

Guest Post – Charting Confidence Intervals

Hi there! I’m Angie Ficek and I’m a program evaluator at a small evaluation consulting firm called Professional Data Analysts, Inc. (PDA) in Minneapolis, MN. In a previous post, Stephanie wrote about adding standard deviations to a dataviz. I responded to her post with an example of…

Read More

What the Hell is Wrong with the Projector & How to Fix It

Meet a hero. This is Kailen Brooks. A few months ago, I was giving a workshop on data visualization to about 40 people at the AEA Summer Institute when pretty much everything that could have gone wrong almost did. Someone’s spilled drink ran dangerously close to my computer.

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

Labels are Used Sparingly

This post is about how to avoid inducing claustrophobia in your data visualizations. Too much text on a graph clutters it up, making readers feel suffocated. So let’s address the checklist item Labels are used sparingly. Sometimes, too much text isn’t the issue. Take…

Read More

Choosing a Color Picking Tool

Giant Wes Anderson fan writing you here. So I loved loved loved it when I saw this Wes Anderson Color Palette blog. It’s like several of my happy worlds colliding into rainbows and unicorns. The blogger pulls color palettes from scenes in various Wes Anderson movies. This screenshot is…

Read More