Are You Chart Smart? 3 Stupid Charting Mistakes

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.

Stupid Chart Mistakes #1 - 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.

Stupid Chart Mistakes #2 - 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.

Stupid Chart Mistakes #3 - 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.

*My apologies to all the Susans that were offended in the making of this pun.

Gavin_Animated-GifGavin is a founding partner at fassforward consulting group. He blogs about PowerPoint, Presenting, Communication and Message Discipline at makeapowerfulpoint.com. You can follow him on twitter @powerfulpoint.

More at Google+Facebook and Pinterest. Comments are welcome, links are appreciated. If you’re interested in writing guest posts for this blog, please contact me.

 

11 Comments

  1. Boris Hristov | October 3, 2013 at 1:04 am

    I have never seen a presentation “utilizing” the TimeLord? Have you really and on what type of presentation?

    • Gavin | October 3, 2013 at 6:48 am

      Boris,

      I’m surprised. I’ve seen plenty. Actually, that’s where the original inspiration for this post came from. I was observing a sales ops review in a Fortune 500 company, and there was a timelord chart tucked in one corner. In this company, they have a habit of squeezing four charts on a page, I think to save space. Naturally this doesn’t help understanding.
      I think sometimes it’s from people wanting to show this years numbers, which they put in the first column or bar, and then follow up with other years, which means (to me) it’s a deliberate, if misguided choice. I’ve seen some which are so obviously the default settings in excel cut and paste into ppt that I am sure that’s how the chart first appeared after clicking the button. The last variant of the timelord, the projection with no dotted line is probably the most frequent.

      Gavin

      • BrsHristov | October 3, 2013 at 7:06 am

        Gavin, I think you need to train them on which graphics needs to be used when and how. What you are saying is really sad! I have seen a lot of bad presentation, but “The Timelord” – that’s too much! :)

      • Gavin | October 4, 2013 at 6:36 am

        Well we try. The first step to learning is becoming aware. LMK if you see any other kind of dumb charting mistakes. Thanks.

  2. Richard I. Garber | October 4, 2013 at 2:38 pm

    Gavin:

    Another problem with the Harlequin Chart is use of vertical labels to go with the vertical bars. Those are reasonable in a magazine article, where the reader can rotate the page 90 degrees to the left to read it. In a presentation you should not ask your audience members to tilt their heads almost ninety degrees left just to read your labels. Use horizontal bars instead.

  3. Susan | November 28, 2013 at 1:32 am

    This is a harsh and totally inaccurate description of all Susans particularly this one! LOL!

    • Gavin | November 28, 2013 at 10:05 am

      :-)

  4. Ivan | January 18, 2014 at 5:11 pm

    What’s the difference between the Timelord and the Australian? are they the same thing or am I just not sensing the difference?

    • Gavin | January 18, 2014 at 7:54 pm

      Good question. They’re very closely related, in that they’re both (mostly) backwards. The Timelord is reserved for those that play with time. Either getting the time backwards, for example years in descending order, or otherwise playing with time, for example not distinguishing between a known quantity (revenue to date) and a forecast quantity (budgeted or forecast revenue). That’s playing with time.
      The Australian is getting the x axis backwards, where it is not a measure of time. For instance, a graph of number of people in the organization on a particular performance management system, and arranging them from best (high-performing) to worst (low-performing).

      I can see the similarity. If we were to draw a venn diagram, some Australians might be Timelords, and most Timelords would be Australian. Someone should tell the people casting Dr. Who ;-)

Leave a Reply