Are you chart smart? 3 Stupid charting mistakes.
I’m sure you use a chart or two in your presentations, PowerPoint decks or ops reviews. Maybe you use four or five. Perhaps you have four or five charts on one slide. If you do, shame on you.
But are you making these three common charting mistakes?
The TimeLord Chart.
On the surface, the Timelord can pass as a normal chart, in the same way a Galifreyan can pass as human. It’s the subtle differences that make this chart a problem. First there’s the utter indifference to the laws of nature and the linear flow of time. For most humans, time flows forward. The year 2010 is followed by 2011, then 2012 and so on. The Timelord turns this conceit on its head. Time flows backwards, from right to left, instead of forwards, from left to right. Then there’s the prediction of the future boldly stated as if it has happened. No dotted lines or subtle shading to indicate a projection or an estimate for the Timelord.
The Harlequin Chart.
Principally the reserve of the color-challenged and the default settings in excel, the Harlequin pops up when showing multiple values and selecting automatic fill in excel. The problem here is all the colors do is show that you have a different category or column. We’re not showing any meaning or pattern, we’re showing a meaningless pattern. Color is a great way of showing something with your data, such as highlighting a particularly successful product line, or grouping together like things. If it’s just used for random decoration, or worse, because you haven’t figured out how to change a default setting in Excel before you import to PowerPoint, it’s just an eyesore.
The Lazy Susan Chart.
The Lazy Susan, AKA the POT, AKA the plain old table, AKA I have a lot of data here and I didn’t know what to do with it, is perhaps the entry-level offender of our line-up of chart criminals. It’s very easy to do when under a time crunch, when you want a little cya in your briefing or you simply want to show how much work you’ve put in to collecting your data. The trouble is that although you may have a lot of data, you didn’t do anything with it. You may want to cya, but it’s just as likely a number you dumped on your slide and didn’t really want to talk about in your ops review is the one that comes up. Tables won’t show patterns, and hide mistakes. They should be used solely for reference and back up, and sparingly in presentations. If you have more than 2-3 rows or columns, rethink how you want to present that data. Don’t be a lazy Susan.*
Have you made these mistakes?
You may have made some of these mistakes. Congratulations young Padawan, recognizing your errors is the first step to improvement. There are some great experts out there that can help. If you want to improve how you handle data, polish your plotting or brush up your bar charts, I recommend you start here.
Storytelling with Data. Cole Nussbaumer.
Excel Charts. Jorge Camoes.
The Functional Art. Alberto Cairo.
NBR Graphs. Naomi Robbins.
*My apologies to all the Susans that were offended in the making of this pun.
You can follow him on twitter @powerfulpoint.