Super Fast Small Multiple Graphs in Excel

Every time I show this trick to even veteran Excel ninjas, their heads explode. So you have probably heard me preach the gospel of small multiples once or twice before. Breaking a clutter-y graph into a lot of smaller graphs that show one piece of data at…

Read More

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 actually display data or assist reader cognition. Create more readability by deleting unnecessary lines.   The default…

Read More

I Failed

This is not news. Today. Yesterday. Every day. I fail all the time. Last week I was playing games that pay real money and failed to get anything out of them. This week, I have so many data visualization fails that I’m already planning a conference talk called The…

Read More

My 2018 Personal Annual Report

This is my last personal annual report. I’ll tell you why. This year most of my metrics went down. At first, due to cultural conditioning that says “more is always better,” I was like Oh no! Before I go further, let’s pause and break that down. I’ve been creating…

Read More

Building a Culture of Effective Data Visualization

The most frustrating part of attending one of my workshops is that you learn so many awesome ways of communicating data, you learn exactly what buttons to push to make it happen, you get hyped up on glee and data vizardry… and then the existing organizational culture stops you from…

Read More

Ways to Visualize Cost-Benefit

Cost-benefit analysis a way of saying “Yes, this program has great impacts… but it’s super expensive.” You’ll often hear the results of cost-benefit analysis in the news, phrased as “For every dollar we spend on this program, we save $$$.” Clients at the University of Alaska, Anchorage (I HAVE THE…

Read More

How to Make Dumbbell Dot Plots in Excel

Data visualization is so cool because it helps you see things that would otherwise take a looooooot of effort. Here’s an example. Some very sweet clients in Maricopa County, Arizona (that’s the greater Phoenix area, friends) had a habit of presenting super important data in the most hard to digest…

Read More

Qualitative Data Visualization: The Gauge Diagram

When we debuted our Qualitative Chart Chooser, we promised to dive into detail on specific visualizations, so let’s kick it off by discussing how and when to use one of the most derided charts of all: the gauge diagram. I know, I know… I am sure you are…

Read More

One Free Pie Chart

If I could, I’d ban pie charts. Not because they are inherently bad, but because most people don’t know the pie chart’s tiny range of acceptability. Here it is: Pie charts are ok if you don’t need the numbers on the wedges to get the story. That usually means you’ll…

Read More

My 2016 Personal Annual Report

Every year I say this has been the best year ever and every year it is true. Daily, I’m grateful for work I love with amazing people. Thanks for being a part of this with me! Since 2011, I’ve been creating a personal annual report. It’s a dashboard of sorts…

Read More