Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

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

The Purpose of Charting

by Jon Peltier
Wednesday, September 17th, 2008
Peltier Technical Services, Inc., Copyright © 2010.
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.

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

Comments


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

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.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

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