PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

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

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

The Purpose of Charting

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Raymond Chen posted recently that The purpose of charts is normally to make information easier, not harder, to understand.

Not always. More often the purpose of a chart seems to be to:

  • Make the presenter look smart, or at least cool.
  • Make the presenter’s product look better than the competition, despite the facts.
  • Accentuate (fabricate) the positive and obfuscate the negative.
  • Hide the fact that the presenter doesn’t know what’s going on.

Raymond backs up his assertion with a counter-example which I presume looks like this, with barely distinguishable green gradients and a useless legend.:

bad bad bad pie chart

You can improve the information transfer by removing the gradients, flattening the awful 3D perspective, and replacing the legend with appropriately located data labels. What do you know, slices one, two, and four are the same size.

bad pie chart

A further improvement is made by changing the pie chart to a column chart. And what else do you know, slice two is not the same size as one and four.

column chart

So pie charts exemplify chart suck, we knew that. So what are charts really for?

You can Use a Chart to See Patterns in Your Data.

Plotted Weekly Production Numbers

Jorge Camoes suggests Using Charts to Validate Your Tables.

US Census Bureau Error

You can use a chart to selectively and interactively display one set of data among many.

You can use charts in a Graphical Approach to Solve a Simple Physics Problem.

physics problem chartphysics problem chart

You can use charts for a lot more purposes, and better purposes, than described in the four bullet points at the top of this post. If you’re careful, you may even demonstrate Raymond’s thesis that The purpose of charts is normally to make information easier, not harder, to understand.

Possibly Related Posts:

Bookmark and share this entry:
  • Digg
  • del.icio.us
  • Facebook
  • Technorati
  • TwitThis
  • StumbleUpon
  • Google
  • Reddit
  • MySpace

Comments

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

Read the PTS Blog Comment Policy.


Comment from Robert Kosara
Time: Wednesday, September 17, 2008, 12:55 pm

While I generally agree with you cynical list of reasons, I wonder about number 4: “Hide the fact that the presenter doesn’t know what’s going on.” I find that a bad or overcomplicated chart makes me ask a lot more questions than if somebody just talks over something s/he doesn’t understand. Looking at the chart, I try to figure out what it’s supposed to tell me, and if I can’t, I keep asking. So this strategy might actually backfire.


Comment from Jon Peltier
Time: Wednesday, September 17, 2008, 1:16 pm

Robert -

I agree. By the same token, how often is objective #1 realized?


Pingback from Sad but true « Open Analysis
Time: Wednesday, September 17, 2008, 2:50 pm

[...] info By jmay Categories: visualization Jon Peltier discusses the purpose of charting, with a bad pie chart as the exhibit on [...]


Comment from Sandi Mays
Time: Wednesday, September 17, 2008, 7:35 pm

I agree with your comment that Pie Charts generally suck. The qualifier is - they suck when you are trying to compare more than 4 pieces of data.

I like the column chart. I am stuck in a rut, where I always use Pareto bar/line combo charts to visually depict the data.


Comment from Jon Peltier
Time: Wednesday, September 17, 2008, 8:00 pm

I think a pie shouldn’t contain more than two segments. Two sections tell as much of a story as a pie can handle, and this is as much pie as I can handle:

(thanks Logic Nest.)


Comment from Tony
Time: Thursday, September 18, 2008, 8:38 am

Would the crumbs be the “gray” area that isn’t labeled in the legend? I do love me some lemon pie though. My yellow slice would be much smaller…


Pingback from Weekly Excel Links - Moved to Seattle Edition | Pointy Haired Dilbert - Chandoo.org
Time: Monday, September 22, 2008, 9:30 am

[...] friend Jon @ PTSBlog asks the critical question “what is the purpose of charting?” and answers it well with several examples. Of course we all think that the purpose of charts [...]

Write a comment





Subscribe without commenting

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