Presentations - The Right Chart, Part 1
This cast describes how to choose the right chart for your data and message in a presentation.
There are so many things wrong with presentations today, it’s almost impossible to decide where to begin. We frankly hope that some larger firms will figure out that it’s worth the time (and therefore budget) to teach all incoming professionals how to give a presentation. The reason one training/HR executive gave for NOT doing this was that all it would do is make their employees more marketable elsewhere. Mark was stunned when he heard it – boy is that a reason never to train anyone. What’s more, there was no acknowledgement of the pain and suffering – and COST – of hundreds if not thousands of presentations every day at any large firm being terribly inefficient, let alone ineffective.
This cast is about one narrow but it seems widely unknown skill involved in developing any presentation: which chart should I use for this slide? We’ve seen too many managers and executives and professionals use charts that prove they’re not aware of how to choose. The right chart makes getting our point across easier. The wrong chart makes getting our point across harder, and can damage the audience’s ability to hear our next point, and potentially undermine the entire presentation.
Here’s how to do it right, for the majority of messages most managers deliver routinely.
- Never Put Excel Cells Into a PowerPoint Presentation - NEVER
- Understand The Difference Between Slide Topics and Slide MESSAGES
- Choose A Pie Chart To Show Parts of a Whole
- Choose a Bar Chart To Show Rankings
- Choose a Column or Line Chart To Show Time Comparisons
- The Acid Test: Can We Understand Without Your Explanation?





Excel in Powerpoint
A few years ago one of my competitors put up a Powerpoint presentation to external analysts on their website. This presentation was the usual light stuff, except it had a table showing some production improvements over the years.
As a competiitor I was naturally interested, so clicked on the slide.....just in case.....and lo and behold up came the original and total Excel document with the complete production details from the last few years, including all data required to fully analyse the manufacturing side of their business.
Without commenting on the morals of accessing the file (or whether the file was deliberately in the document), the lesson is clear, never, ever, ever, put an Excel document into a Powerpoint presentation.
Tufte reference
For the more technical aligned guys- you may find this website interesting:
http://www.edwardtufte.com
This contains a very detailed analysis to show how misuse of powerpoint and graphs can lead to seriously flawed decisions (particular case used is the tragic Challenger Space Shuttle accident and the decision to launch).
Tufte resources contains some extremely powerful guidelines about how to clearly present data.