I was presenting the Mindworks Presentation Method to a team at Microsoft this week and I asked them what challenges they had creating PowerPoint slides. One person commented they wanted to know how to make dry, boring slides more exciting.
Their exact words were “The slides were so dry, you could have started a fire.”
Fair enough. Here are five ways to present dry data in more exciting ways.
1. Sankey Diagram. Rather than present data in a table, you can convert it into this slick-looking Sankey Diagram. These diagrams use lines of different widths to show how something flows through a system, like cash flowing through an income statement or customers flowing through a website. The width of the line indicates the value (the length of the line has no meaning). Creating it takes some artistic skill and patience creating shapes and aligning them perfectly. But it looks pretty slick, doesn’t it?
|After: Sankey Diagram||Before: Table|
2. Proportional Diagram. This diagram replaces a boring pie chart. By using shapes (like circles) to represent each percentage, the audience sees these as “real things” and not just an abstract glob of pie chart. For instance, if each circle represents a number of customers, the audience can feel how much work is involved in winning back these customers. See Dave Paradi’s video for a larger discussion of proportional diagrams. Stephen Few calls them unit charts.
|After: Proportional Diagram||Before: Pie Chart|
3. Logo charts. When you have a series of stacked bar charts side by side, it’s sometimes difficult to see patterns and compare the values of each bar. Instead, you can create a diagram that ranks these items. Logo charts are an invention of Jon Moon (named because it may involve representing different companies or products as logos, rather than text) and explained in his book How to Make an Impact.
|After: Logo Chart||Before: Stacked Bar Charts|
4. Deviation bar chart. When you have data with two opposite values (like negative/positive) it’s better to create a common baseline so the height of the negative and positive values are more obvious. To create a deviation bar chart with a common baseline, just use a negative number instead of a positive number for the negative value (eg. For “Disagree”, change “2” to “-2” in Excel). Voila! The negative values shift into negative territory and create an invisible baseline
|After: Deviation Bar Chart||Before: Stacked Bar Charts|
5. Stacked text chart. Instead of showing a table with yes/no values for different columns, convert that into a stacked text chart. Color code the yes boxes a dark color and the no boxes gray. Add thick white borders to the table cells to separate the boxes, or else create the boxes using shapes and leave whitespace between them.
|After: Stacked Text Chart||Before: Yes/No Table|
What other ideas do you have for making boring data slides more exciting? Leave a comment below.
About the author: Bruce Gabrielle is author of Speaking PowerPoint: the new language of business, showing a 12-step method for creating clearer and more persuasive PowerPoint slides for boardroom presentations. Subscribe to this blog or join my LinkedIn group to get new posts sent to your inbox.