PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Site search


Recent Posts

Recently Commented

July 2008
S M T W T F S
« Jun   Aug »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive


 

Categories


 

Bar graphs vs. Pie charts

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

The three laws of great graphs contains Seth Godin’s guidelines for charts used in presentations:

1. One Story
2. No Bar Charts
3. Motion

In Seth’s Three Laws of Great Graphs, I agreed in principle, but suggested changing item 2 to “Choose Chart Types Intelligently”, because bar charts are not intrinsically worse than any other chart type.

In Bar graphs vs. Pie charts, Seth further explains his comments about bar charts:

[T]he purpose of a chart or graph is to make one point, vividly.

I think we’re in agreement on this point. Seth mentioned non-scientists, so I guess another underlying theme is “don’t make them think about this information”. I think we can agree that sometimes that’s also our intention.

Seth showed a pie chart which is used to get the audience to agree that we need to address the issue of Trolls (the following is my recreation of Seth’s chart; it’s essentially the same using Excel 2003’s inferior formatting effects):

Yes, it clearly shows the dominance of Trolls over the other creatures, as Seth points out. As long as a pie chart is used in this context (”See, Trolls make up the largest sector of our target market”), then I guess it’s pretty innocuous.

I guess it’s a matter of taste. I still prefer a bar chart to show the relative sizes of the categories:

In fact, using data from a bar chart Seth posted next to the pie, I’ve constructed a compound bar chart that readily shows that not only are Trolls a problem this year, but they were also a problem last year, and are projected to be a big problem next year, if we don’t act now.

This one will convince even the most numerically illiterate (”innumerate”?) in the audience. If you tried this with three pies, you’d only cause more confusion.

Seth finishes by saying

I can think of dozens of good uses of bar graphs… they’re not forbidden, they’re just overused and misused.

I can think of many good uses for several chart types, and no good uses for others. Charts with gratuitous 3D and formatting effects are among the most misused, abused, and overused of all chart types, and should be forbidden. Pie charts are also abused and overused, and if not forbidden, should be placed on probation. The major chart types I use (bar, line, and XY charts) are certainly abused and misused, but I wouldn’t say that well made ones are overused by any means.

Share/Save/Bookmark

Comments

Comment from Nat
Time: Sunday, July 13, 2008, 9:55 pm

I would say that for the purposes of the “message” Seth wants to put across “focus on trolls” I think that the pie chart does a better job.
I agree with him, however Seth is not using the chart to transfer information, but to emphasise a message. In this case it is better to view the pie chart as not a chart but as an image or a graphic and its statistical accuracy is not then the compelling measure of it’s effectiveness.


Comment from derek
Time: Monday, July 14, 2008, 2:52 am

Then a cartoon picture of a scary big troll would be even better at getting the message across. The dishonesty of using pie charts as a propaganda cartoon is that your audience comes out of the room thinking they’ve been shown some information. They’re wrong, but it’s a common and exploitable error, like bar charts that don’t start at zero.


Pingback from Visual Business Intelligence - Godin’s Silly Rules for Great Graphs
Time: Monday, July 14, 2008, 12:46 pm

[...] by Godin’s argument, because Jon Peltier has already done so with great dispatch in his blog. I would like to address Godin’s final rule, “Motion,” which he elaborates by [...]


Pingback from Godin’s Silly Rules for Great Graphs | Dashboard Blogs - Examples & Tutorials
Time: Monday, July 14, 2008, 4:30 pm

[...] by Godin’s argument, because Jon Peltier has already done so with great dispatch in his blog. I would like to address Godin’s final rule, “Motion,” which he elaborates by [...]


Pingback from DSA Insights » Blog Archive » Donut Charts!
Time: Monday, July 21, 2008, 8:04 am

[...] Jon Peltier [...]


Pingback from Seth Godin on graphs in presentations « OECD Factblog
Time: Friday, August 1, 2008, 10:14 am

[...] Camoes wrote: No bar charts - a caricature. Jon Peltier: “Pie charts are also abused and overused, and if not forbidden, should be placed on [...]


Write a comment





Create Excel dashboards quickly with Plug-N-Play reports.