Mike Pulsifer Photography mike-pulsifer.org

29Dec/080

Improve Your Slide’s Charts

Types of slides that we often create are those that try to present data to our audience. All too often, this data is placed in a cluttered data table or worse, is presented in a narrative format. In most cases, a chart of some sort is the appropriate method of presenting data. However, there is an art to doing it right. A poorly formatted chart can be just as bad as that useless narrative on the screen.

In my experience, I've seen far more bad charts than effective ones. Often, the reason is expedience or because someone decided "hey, this looks cool!" An exotic sports car with a broken transmission may look very cool, but it's not going to get anywhere. Likewise, a poorly thought-out chart may look cool, but it's useless without an explanation.

We've got 3 seconds for that chart to convey its information in support of our story.

When creating a chart, the first thing we need to ask ourselves is, "what is the most important information?" The key words there are "most important" and "information." Information and data are not the same. Data are the raw numbers and figures. There's nothing more to them. Information is the message or story being told by the data. Data by itself will not translate into information. What we do to the data will provide us with information.

Secondly, we need to focus on which information is most important. Depending on how you present your data, the information will be different. I'm sure you've heard the phrase, "Lies, lies, and damned statistics." Well, it's true. How you manipulate or present data affects the message being presented. Let's look at two charts that contain the same data, but because of a different presentation, tell a different story.

Bad Pie Chart

Bad Pie Chart

For this example, I took the number of level 80 characters is one of my World of Warcraft guilds and created two different charts. The data is exactly the same in each. In the pie chart, the data is represented as percentages of the total while in the bar chart, the data is represented by the raw numbers. The message contained within both, while truthful, are misleading. In the pie chart, you have a large number of slices that well crammed into one chart minimizes the difference between them. Though you can interpret correctly that there are twice as many druids as there are warlocks, the visual and mental effort required to get there is more than is necessary. Without the labels, all we can do is guess at the relative values. In addition, since all we see are percentages (fractions of one whole pie), we lack any information about the size of the guild.

Keynote Bar Chart (before)

Keynote Bar Chart (before)

The bar chart tells a completely different story. Here, you've got a more apparent representation of the relative class populations. Is the chart poorly formatted? You bet. I'll get to that in a moment. However, in this example, it's immediately apparent that the warlock population is very small. A simple glance and the two bars tells that story in 3 seconds or less.

Bar Charts

Now, with that said, the relative populations of each of the classes is not what my most important information was. The information I wanted to convey was the population of death knights, added to World of Warcraft this past November, relative to to the other classes. The other bar chart example, this time from PowerPoint also fails to convey this information. In both the Keynote and PowerPoint examples, the chart settings were left mostly to their defaults. Below are the major problems with these charts:

PowerPoint Bar Chart (before)

PowerPoint Bar Chart (before)

  1. 3D In this example, PowerPoint's default is to present a 3D chart.  The problem with 3D bar charts is that they lie to us.  They give the bars more surface area than is necessary, and which is often out of proportion with reality, especially for the smaller bars.  Take for example, the same chart displaying data for one of my other guilds.  This chart has two bars with a value of 0, yet they have surface area.  Thus, visually, these two bars appear to have value when in fact they don't.
     
  2. Inappropriate Title  These charts are titled, "Classes - D'Gentlemen."  Though it is true that these charts are displaying the number of level 80 characters in D'Gentlemen, sorted by class, that's not the most important information.  What's most important is the number of death knights relative to the other classes.

    PowerPoint Bar Chart #2

    PowerPoint Bar Chart #2

  3. Bar Colors Obscure the Message  When displaying multiple data points, it's not necessary to always give them their own color.  Remember, what's most important in these charts isn't each bar relative to the other 9.  What's most important is the value of one specific bar relative to the other 9.
     
  4. Sort Order Obscures the Message  When displaying multiple data points, be mindful of the sort order.  Sorting them alphabetically doesn't always make sense.  Reordering the bars by value (alphabetically as a secondary sort) drives home to the audience the relative population of death knights in a manner that takes very little visual effort.  The eyes don't have to bounce all around the chart to put all the pieces together.  

    Keynote Bar Chart (after)

    Keynote Bar Chart (after)

  5. Chart Junk  Edward Tufte refers to the stuff on a chart that doesn't add value to the chart "chart junk."  In this case, the border of the chart, the grid lines, legends, and the numbers down the left all contribute to a data:ink ratio that is out of whack.  None of that contributes to the easy absorption of the data.  Because of limitations of presentation slide software and the nature of the data, our best option here is to place the value of the data points right there on the bars.

 

PowerPoint Bar Chart (after)

PowerPoint Bar Chart (after)

Once we clean up the problem areas of these charts, we're presented with two completely different representations of the same exact data.  However, this time, the information that is most important is what is conveyed to the audience.  The title was changed to "Death Knights - D'Gentlemen," the data points were reordered and all of the bars, with the exception of "Death Knight," are the same color. 

Pie Charts

Keynote Pie Chart (before)

Keynote Pie Chart (before)

Another popular chart type is the pie chart.  One key thing to remember with these charts is the information conveyed is always the data point as a percentage of the whole.  Even if the labels show raw numbers instead of percentages, the message that your audience receives is that of a percentage or fraction.

PowerPoint Pie Chart (before)

PowerPoint Pie Chart (before)

My two examples of the before versions of PowerPoint and Keynote slides are of the 3D variety.  Though not the default, they are by far the most popular.  These charts are intended to convey the population distribution among the different races in my World of Warcraft guild.  Let's look at where these charts fail us:

  1. 3D  It can't be said enough that 3D charts lie.  In the Keynote example, the 10% slices look just a little bigger than they should, all because of the illusion of perspective.  In the PowerPoint example, because the gray slice is just as tall as the green slice, the gray slice appears to be bigger.  This is because with a 3D pie laid out as it is, our brain expects the gray slice to be shorter.  The rules of perspective dictate that identical height objects at different distances appear to be different heights, with the one furthest away being the smaller.  You also have the same problem you have with bar charts where smaller data points get extra surface area than they should get, proportionately. 

    Keynote Pie Chart (after)

    Keynote Pie Chart (after)

  2. Texture and Colors  The Keynote example is using its default fill texture.  Marble doesn't add any value and instead distracts the eyes with a lot of visual noise.  Many extraneous lines are added when only a few, those that separate the pie slices, are important.  The PowerPoint slide uses colors that just don't contrast enough and lets slices "hide."
  3. Lack Of Values Leads To Guessing  The lack of data values in the PowerPoint example leads to guessing about the relative sizes of the slices.  The legends in both leave a lot to be desired, but Keynote can move that information to the slices without compromising too much (depending on the slice sizes).  PowerPoint can move this information to the slices as well, but the size of the chart is sacrificed too much. 

    PowerPoint Pie Chart (after)

    PowerPoint Pie Chart (after)

  4. Chart Junk  The PowerPoint example contains the usual chart junk:  chart borders and slice outlines.

I cleaned up the charts by flattening the charts, simplifying the colors & textures, using more dense and informational labels (where I could), and eliminating chart junk.  The new slides should be more effective when presented to an audience.

24Dec/080

Merry Christmas

I'm returning to the land of the living after a cold over the weekend and blog content should start appearing again this weekend.  In the meantime, have a very merry Christmas.

Watch more video games and play free games at WeGame.
Tagged as: No Comments
14Dec/084

PowerPoint 2004 vs. Keynote ’08 – Part 2

In my last post, I looked at the basic features of PowerPoint 2004 and Keynote '08.  This time, I'm going to take a look at the two applications from the viewpoint of someone preparing to or actually delivering their presentation.  I will also be looking at the various export options should you need to make your slide deck available after your presentation or if your delivery method needs to be a little unorthodox. (Note:  I have corrected in an error in my last post.  Diving into Preferences does amazing things.)

Adapting To Your Audience

If you're someone that delivers the same presentation to several audiences, you might find that you have to customize your deck, either adding or removing slides.  In PowerPoint, your solution is to create a custom show.  You have to choose Slide Show --> Custom Shows --> New and select the slides you want and reorder them if necessary.  The functionality is quite buried and you're forced to go through quite a bit of effort just to exclude one or more slides.

Keynote provides a "skip slide" option that allows you to do just what it says:  skip the slide.  The slide is still in the deck.  Nothing's deleted.  However, when playing the slide show, you won't see the skipped slides.

Rehearsing

Rehearse in PowerPoint

Rehearse in PowerPoint

Both PowerPoint and Keynote offer options for rehearsing your delivery.  Both assume (correctly for most of us, I presume; myself not included) that when rehearsing, we have just one monitor.  PowerPoint displays the slide, full screen, with a small (and I mean tiny) timer in the bottom right corner.  It's as though you're presenting while looking at the big screen and your back's to the audience.  Certainly not what you would be doing if it were real; at least I hope not.

Rehearse in Keynote

Rehearse in Keynote

Keynote takes a different approach.  Keynote displays what the presenter would see if they had their laptop in front of them while facing the audience.  The benefit is clear.  The closer the practice environment is to the real thing, the more comfortable and natural the presenter will be when the heat is on.

Show Time!

PowerPoint Options

PowerPoint Options

When it's time to deliver our presentation, if we can have access to our laptop's screen, then it would be helpful for it to display what we need and only what we need, if anything.  It should be no surprise that both PowerPoint and Keynote offer a customizable display.  It should also be no surprise that both differ in their approach and their depth of customizability.

Presenting in PowerPoint

Presenting in PowerPoint

PowerPoint's customization options are very limited, allowing us to only change the playback options.  There are no options for changing the appearance of what the presenter sees.

Slideshow Options in Keynote

Slideshow Options in Keynote

Keynote provides more options for the presenter, providing two tabs in the preferences window:  one for the slideshow and one for the presenter display.  There is even an option to edit the layout of the screen that the presenter sees by dragging the various objects around in addition to adding and removing elements.  You even have the option to change the timer display.

Presenter Options in Keynote

Presenter Options in Keynote

Presenting in Keynote

Presenting in Keynote

Recording Yourself

Audio Options in PowerPoint

Audio Options in PowerPoint

Both PowerPoint and Keynote offer the option to record your speech as you step through the slides.  Keynote allows you to record your audio or add a soundtrack from within the inspector.  You can add your soundtrack from iTunes, which is more functional than any file system.  PowerPoint has a separate dialog for recording your audio and only allows you to add a soundtrack through the "Make Movie" option in the file menu. PowerPoint doesn't offer any integration with iTunes.

Audio Options in Keynote

Audio Options in Keynote

Exporting

Both applications allow you to export your slide deck to a wide variety of formats.  What does seem clear from the options, tough is that while Microsoft's options are mostly just different means to dump output to different image formats, Apple thought about how the audience might want or need to consume the content.  Below are the options:

PowerPoint Keynote
QuickTime Movie
PDF (print dialog) PDF*
JPEG*
PNG*
TIFF*
PICT PPT
GIF Flash (can include audio)
BMP iPod
Web Page

* = Keynote allows you to step through slide builds.

All in all, you'll probably find PowerPoint 2004 could still work for you if you need to use it once in a blue moon and if you already have it.  However, if you use presentation slide software with any regularity or if you're choosing between PowerPoint or Keynote, save your money and use the less expensive tool that the pros apparently have good reason to use:  Keynote.

7Dec/089

PowerPoint 2004 vs. Keynote ’08

Having read in books and online how great Keynote was and how the pros use it over Keynote, how could I not spend the $70 on iWork and give it a spin?  The version of PowerPoint that I have to compare Keynote to isn't the latest and "greatest," but as some may argue, with the lack of macro support in Office 2008, the older, PPC-based version may be the better of the two Microsoft offerings.  Personally, all I have is 2004 and given how I can't support Microsoft's anti-competitive no-macro move, Office 2004 is what I've got.  Also keep in mind that this is based on early impressions and early, limited use, so if I'm just not figuring something out and you know the answer to what I'm looking for, then please feel free to share.

Templates

So, when I'm creating a new slide deck, I'm typically not one to use built-in templates.  In fact, given my long history with PowerPoint on Windows, that's the wise approach.  Microsoft's templates are just atrocious, hideous, and simply not professional.  For all we know, they hired a monkey to throw poo at Windows Paint.  They just aren't conducive to readability.  The template is the star of the (B-movie) show, not your content.  What's worse is that if you did want to use one of their templates, PowerPoint sure isn't that helpful.

PowerPoint Templates

PowerPoint Templates

You have two ways to choose you design.  One is through the formatting palette and the other is through a Finder-based dialog.  The thumbnails in the palette are too small to be useful and essentially require you to choose them one at a time to really get a good idea what it's about.  The dialog is even worse because you're choosing them by name, with no thumbnail or preview at all.

Keynote, on the other hand, actually has me considering using their templates (called themes), even if just the simpler ones.  You're presented with usable thumbnails in an easy to navigate dialog.

Keynote Templates

Keynote Templates

The themes are also quite intelligently designed.  Unlike Microsoft, Apple apparently employed real designers with a knowledge of the fundamental concepts of what makes text readable.  They are also, for the most part, simple enough to not be too distracting.  I took a PowerPoint slide deck I created and applied one of the built-in Keynote themes and got what instantly looked more professional even though the original design and Keynote theme were similar in concept.  In Keynote, it's more polished right off the bat.

Interface

PowerPoint Interface

PowerPoint Interface

So, now we've got our template chosen, let's take a look at the interface.

Office 2004 is famous for straddling the line when it comes to obeying the Mac Human Interface Guidelines.  On the one hand, they put the controls in a (mostly) easy to use formatting palette, yet they still give you a Windows-ish toolbar.  You can close the toolbar, but you'd lose access to some functionality, such as the format painter.  Truly bad interface design.  With that said, it's still much more elegant than the Windows version.  It's as though the Mac Business Unit at Microsoft tried to build a compliant UI, but overlords in Redmond weren't going to allow them to stray too far from the ranch.

Keynote Interface

Keynote Interface

Keynote, on the other hand, puts the toolbar, front and center, and attached to the document.  Huh?  Say what?  Yeah.  The very thing you're not supposed to do to Mac apps, Apple did.  The very thing that makes no sense (attaching toolbars to documents rather than the application itself), they did.  You know what?  I don't like it.  Yeah, they're easy to access and they're far more usable than their Windows counterparts, but I really resent losing that form of real estate.  I don't think splitting duty between the menu bar and the toolbar is good interface design.  The application/document relationship we have come to understand because it frankly makes sense has been turned sideways and upside down at once.  With that said, you can turn the toolbar off and not lose access to any functionality.  They do provide an inspector palette, which does make me feel at home, for what it's worth.

Adding slides to your deck is also different between the two.  In PowerPoint, your primary interface for this is under "Add Objects" in the palette.  I prefer to use a blank slide as a starting point when designing my slides, so I have to scroll down to find what I want.  Even if a blank slide isn't what I'm looking for, the various designs would likely require scrolling to find what you want.

Keynote takes a different approach.  When you click "New," it creates a new blank slide for you.  Hey, what do you know, it creates exactly what I want by default!  If you want to change the layout of the slide, click the Masters button in the toolbar and you'll get a list (no scrolling) of your options.  The thumbnails you are provided in the drop-down list actually have your theme applied to them so you have a better idea what you're getting yourself into than in PowerPoint.

Going Full Bleed

One of the tricks for cross-platform builds in PowerPoint is to use your full-bleed images as individual slide backgrounds.  This prevents all kinds of odd-behavior in going between PowerPoint 2003 and 2004.  One of the things that PowerPoint also does is it will scale your slide and everything in it to the resolution of your screen or projector.  Keynote provides the option to scale to the size of the screen as well, through the preferences. -added 12/14/2008 Keynote takes a different approach.  Rather than risking the distortions and pixelations that result when rescaling graphics, you create your slides with a specific resolution.  Each approach has its benefits.

PowerPoint:

  • Your slides will fill up the screen no matter what you're projecting on.  You don't need to think about what type of projector you're going to be using.
  • Individual slide backgrounds allow your image to be free from accidental dragging.
Keynote:
  • Almost all projectors project at 1024x768, so scaling may not be an issue.
  • No distortions or pixelation of images

Pick your poison.

Design

PowerPoint Guides

PowerPoint Guides

One of the things that's useful when laying out graphics and images on a slide is some sort of guide that shows you the power points as defined by the rule of thirds.  When turning on guides in PowerPoint, you're presented with two guide lines, which can be moved.  In all my time using PowerPoint, I have yet to see a means with which you can add guide lines.  It's either not there or not obvious.

Keynote Guides

Keynote Guides

Keynote, on the other hand, allows you to drag new guide lines from the rulers to your slide.  In addition, the rulers just make sense.  In PowerPoint, the rulers seem to be in at least the equivalent of inches.  10 "inches" across the top and 7.2 along the side.  Each major mark (an inch, I guess) is divided into 8ths.  Since PowerPoint (Keynote won't either) doesn't give you the thirds laid out with the guides, you've got some calculations and approximations to do.  Keynote's ruler is divided into 10 major units along the top and along the side.  Each major unit is divided into 10ths.  Now, you tell me which is more useful?

Media

PowerPoint likes to throw you right into the clip-art folder whenever you want to add an image as a background (the PPT hack I described above).  I have yet to figure out a reason for this bizarre behavior.  It's extremely annoying and just obnoxious.  Given the clip art included with Office, nobody should even want to use what's in that folder.  Fortunately, adding an embedded image doesn't share this behavior.  That's good, but it also sheds light on the inconsistent and seemingly hap-hazard user interface decisions by Microsoft.

Media

Media

Keynote offers excellent integration with iPhoto, through a media dialog that shows you what's in your iPhoto library.  Just drag and drop.  You can also choose something outside of iPhoto if you wish.  Unlike PowerPoint, though, you don't need to specify what kind of file it is before you do so.

Charts

If there's one universal truth, it's don't copy your charts from another program and paste them onto your slides unless there's just no way on this green earth your slide application can handle the task.  If you've ever seen an Excel chart pasted into a PowerPoint, you know what I mean.  Both PowerPoint and Keynote have the capability of adding charts.  However, the approaches the two applications take couldn't be more different.

PowerPoint Charts

PowerPoint Charts

PowerPoint starts you off with a bar chart with 3 data series and 4 data points.  The default chart is full of what Edward Tufte calls "chart junk."  It's 3D, has unnecessary borders, rules, and values on the Y-axis.  Oh, did I mention, PowerPoint launches another program for this?  While working on your PowerPoint chart, you're actually working in an application named Graph.  This isn't just a Office 2004 thing.  Office 2003 for Windows does the same thing.  PowerPoint offers a seemingly limitless palette of colors for your potentially limitless number of data series.  Of course, only if you want to lose your audience while they're trying to decipher your chart, would you use that many data points.

Keynote Charts

Keynote Charts

Keynote doesn't launch a separate application to create your charts.  The default chart starts you off with 2 data series and 4 data points.  The starter chart is also in 2D.  Big deal?  Not really.  However, it does seem to suggest to the user a smarter use of charts in this context.  The data entry mode is through a dialog and all updates are reflected in the chart real-time, unlike in PowerPoint.  Chart colors are limited to only 6 for the chart.  Though limiting, if you looking to add more than 6 data series, then you need to rethink your chart.  Any more than 6 will surely create visual clutter.  I would even find it hard to get up to that number of unique colors.  Rather than diving through dialogs for each data series like you do in PowerPoint, changing colors of individual data series is done by dragging and dropping from the chart colors dialog to the series in the chart.  This is much easier and far more efficient.

Summary, for now...

As you can see, I've very impressed with Apple's presentation slide software, Keynote '08.  For a relatively new entrant into the space, Apple has shown they have more than enough of what it takes to compete effectively and give presentation professionals a tool worth choosing, even as a first choice.

As I mentioned earlier, I'm fairly new to Keynote, so what I've shared thus far is based on early impressions.  There's more I have yet to explore, such as video integration, export options, etc.  My next article on these two applications will cover features used when presenting.  These two are in a class of their own, both far more useful in actual presentation mode than their Windows-based counterparts.