PTS Blog

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility
PTS Dot Plot Utility
PTS Cascade Chart Utility

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the whole blog has been helpful, support further development by treating me to a cup of coffee.


Privacy Policy

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

Ineffective Chart – Partition Chart Revisited (Defragged)

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

In Ineffective Chart – Partition Chart, I discussed the partition chart that Chandoo spoke of in Partition Charts in Excel – alternative to pie charts [visualization hack]. I felt that the partition chart hid the data it was meant to present. Jorge Camoes remarked that it looked to him like the map of a fragmented hard drive’s file system.

In Partition Charts – Continuation – [More visualization fun] Chandoo has reworked his partition chart, defragging it to bring all same-colored squares together. The original chart

Partition Chart in Excel

now has just three contiguous colored regions

Partition Chart in Excel - Defragged

That looks less cluttered than the original chart with its distracting camouflage effect, but by eye, I still can’t really resolve the difference between 30% light orange and 22% brown, and those numbers aren’t really close enough to be uncertain about them. The pie chart I used in my post showed these values more readily.

Pie Chart in Excel

As always, the simplest and clearest way to show this data is in a bar or column chart:

Bar Chart in Excel

The defragged partition chart reminds me of the “square pie” we first read about in Eager Eyes (Women in IT – Squaring the Pie?), and which was taken up by Juice Analytics (Squaring the Pie), Dashboards by Example (The Square Pie Chart), Anil Dash (Pixels Are The New Pies), Info Clarity (A square pie), Bella Consults (Square pies taste bad), and others. Here are some examples:

Square Pie Chart
Women in IT


New York Times (left) cited by Anil Dash and Juice Analytics.
Wired Magazine
(right) cited by Bella Consults and Dashboards by Example.


Produced and cited by Info Clarity

The square pie chart was all the rage for a while. Consensus seemed to be split between “they’re wicked cool” and they’re even less effective than round pie charts. My own opinion is that they are ineffective: the awkward shapes imposed by rows and columns of filled squares make comparison of areas even more difficult than comparing areas of rectangles with unequal lengths and widths or comparing areas of rotationally misaligned wedges in a pie chart.

Bottom line: you shouldn’t use square pies or “defragged” partition charts, use a bar chart instead.

Possibly Related Posts:

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

Learn how to create Excel dashboards.

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

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility PTS Dot Plot Utility PTS Cascade Chart Utility

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