UPDATE: This post was written in 2014 and my thinking has evolved since then. Here’s the newest post on how to handle all of your axes.
Don’t kick me out of the dataviz club for this.
For a long time, folks have been adamant that the y axis has to start at zero. Otherwise, we are exaggerating the scale of the graph, distorting data, and lying like we work for Fox News. I’ve had my reservations about this but been comfortable pushing the Start at Zero movement simply because its a common mistake most novice graphers make.
So there I was the other day, giving a dataviz workshop inside a super giant corporation, preaching the Start at Zero gospel. And this person in the audience says “Whoa wait. I mean, come on. We have so many instances in our review meetings where the data really don’t fluctuate very much but a rise of 0.4% is a big deal to us. With a graph that starts at zero, we won’t be able to detect these changes.”
PEOPLE. HE’S RIGHT.
Look at this mess (it isn’t his data):
Nobody can do anything with that. One option is to break it in to small multiples. But even then, it isn’t going to help this team see small changes in the trend lines. So let’s sin and change the y axis so that it begins and ends just on the other side of our lowest and highest values:
So here’s the deal: I think it’s totally cool to change the start and end of the y axis SO LONG AS you are keeping the data internal. If you have a group that looks at this data consistently and needs to detect small change and they’re all in on the fact that the slope of the line is distorted because the axis is different and you PROMISE not to leak it out to the public, go for it. But these are the rules! Once again:
1. You keep it internal.
2. Everyone knows its different.
3. Tiny changes in the metric mean big things to you.
Dataviz needs to be useful! Use first!
In other news, I’ve updated my Upcoming Events calendar. If I’m in your area, let’s hang out and talk about Excel (and drink beer)!
Also, I started a new podcast with Jon Schwabish – The Rad Presenters Podcast. Subscribe now – Episode 2 will be posted next week.