This morning I keynoted a conference in Tallahassee. Data visualizers who critique others before critiquing themselves make me gag, so I opened my talk with a trip down memory lane.
Check out this beauty from one of my earliest jobs. I’ve anonymized it but 99.9% of my work from this period had this look and feel, i.e., an overly-labeled graph that I made in Excel and pasted directly into Word without any editing at all.
Redundancies made my graph look more complicated than it really was.
- The title and the y-axis label were redundant.
- The numeric labels on each data point and percentages listed down the y-axis scale were redundant.
- If we’re going to label individual values on the graph, then we no longer need grid lines.
- The full time period is unnecessary. This graph’s viewers–decisionmakers in a state education agency–would know that ’08-’09 means the 2008-2009 school year.
- The markers (tiny squares) along with the numeric labels are redundant.
- The control group’s dotted line and gray color are redundant. I often use dotted lines to represent projections so I removed the dotted lines here.
- The legend leads to unnecessary zig-zags around the page. Direct labels are faster to read and hold up better in black/white printing scenarios.
- And so on…
At the time, I adored these graphs because each graph represented hours of data cleaning and good ol’ fashioned hard work. I knew so much about number-crunching but so little about graph-making, and I was probably too tired after all the analysis to even think about the visualization. Plus, this was 2008. Let’s be honest. Everyone’s graphs looked like this in 2008.
Recently, I’ve been showing you one tip at a time, like deciding how far you’ll stretch your scale, whether you’ll use a regular or stacked chart, and whether your chart will be oriented vertically or horizontally. Today, let’s check out how lots of small edits–small deletions, in this case–add up to completely makeover your graph.
Continue scrolling for the play-by-play edits:
Intentional subtraction still blows my mind every time.
Purchase the template ($5)
Ben Collins
Feb 28, 2017 -
Amazing how much more readable the new version is! Thanks for sharing the transformation. I’d be tempted to go one step further and remove the y-axis altogether…interested to hear your thoughts on that? It would maybe leave the lines floating though, and the chart would perhaps lose some impact.
Jared Hansen
Mar 9, 2017 -
Great transformation! One question I have is when I look at this is why did you start the y-axis 30%?
Evan H
Apr 3, 2017 -
Really love this post. Helped me with cutting down numbers and lines in my own graphs.
Ann K. Emery | Pie Chart Makeover: Transforming a Research Report
Apr 25, 2017 -
[…] Here’s a screenshot from one group’s (public-facing) research report. The authors of the report talked about wheelchairs that were given to people in other countries. This was the demographic section of the report so there were a few graphs showing who those wheelchairs went to — men, women, kids, adults, and so on. There are 3D pie charts but I don’t fault anyone for their before graphs. We’ve all been there. […]