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.

Climate Change Survey Results

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

Dustin Smith’s World Opinions on Climate Change article in Chart Porn blog pointed me to an attractive but ultimately ineffective graphic. The road to Copenhagen Summit on Whatype blog presents results of a 2007 World Public Opinion survey of worldwide public sentiment over global warming-related issues. The graphic is reproduced in small size below; click on the image for a full size view.

iso-cub pie chart survey results

It’s eye-catching. It also is difficult to read, because of the use of irregularly-shaped polygonal areas to encode values. In fact, the graphic sticks several square pie charts together to make cubical square pies. I addressed square pie charts in Ineffective Chart – Partition Chart Revisited (Defragged), where I noted:

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.

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.

As with so many ill-advised charts, a more effective replacement is a bar chart. Here is the Chart Busters version:

boring bar chart survey results

I suppose if you felt you had to, you could apply similar colors to those of the cubical square pie chart.

colored bar chart survey results

The colors may add to the chart’s ability to get attention, but they may actually detract from its ability to convey information.

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 Mathias
Time: Tuesday, November 3, 2009, 1:25 am

Amazing how people get out of their way to create ever-more fancy looking and unreadable charts, where the good old bar chart tells the truth, all the truth and nothing but the truth so effectively… As a member of the color-blind tribe, I can tell you that there is no way I can get the story behind the cube without effort – but spotting the peaks and valleys (if this is an adequate way to describe it, given the horizontal layout!) in a bar chart is a breeze.


Comment from Chandoo
Time: Tuesday, November 3, 2009, 4:47 am

Cubicle square pie chart.. .gosh, I cant imagine the reason why some one would even think of making this. If only people are made to buy carbon credits to make chart pollution…

Thanks for the wonderful advice Jon.


Comment from jeff weir
Time: Tuesday, November 3, 2009, 11:22 pm

C’mon guys…EVERYTHING is going 3D these days. Hell, down here in New Zealand we even have a 3D newspaper – check out http://www.3news.co.nz/3D-newspaper-pops-up-in-Taranaki-/tabid/421/articleID/126158/cat/52/Default.aspx

And as with newspapers, if I print these charts out they are perfect for wrapping my 3D fish and chips up with.


Pingback from Dashboard Best Practice – Google Analytics Intelligence Report | Pointy Haired Dilbert: Charting & Excel Tips – Chandoo.org
Time: Wednesday, November 4, 2009, 5:32 am

[...] basic charts – Often we fancy ourselves to use some super-complicated-chart. Heck, Jon reviewed (more like lambasted) a 3d Square Pie Chart just yesterday. See how Google has used simple line and column charts to make the point. It is the [...]


Comment from gerdami
Time: Wednesday, November 4, 2009, 8:20 am

Dear Jon,
I am currently visiting your blog with a laptop and screen width of 1024px, which is certainly not unusual amongst your subscribers. Your blog then displays a non-user friendly horizontal scrollbar.

Thanks to FireFox’s firebug plugin, I noticed within the associated CSS file that the width of your “div” named “wrap” was set to 1060px.

#wrap {
background-color:#FFFFFF;
color:#333333;
margin:0 auto;
width:1060px;
}

Please lower width to 1010px and it will fit perfectly on laptops like mine.


Comment from DaleW
Time: Saturday, November 7, 2009, 6:52 pm

At the risk of being considered contrarian, I feel that this, well — Rubik’s cube tribute chart — is a perfect chart for this data.

It would be a tragedy if good and meaningful data were lost in a chart like this.

However, it’s more of a comedy when such soft, feel-good data from a self-serving opinion survey is presented in such pretty but puzzling form. This chart format really is inherently more interesting than the results being presented here.

Consider: by a 7:2 margin, these nonrandom respondents for the world admit to placing a higher rather than lower priority on climate change than the general public. What next? A survey of largely Microsoft employees to see if they believe Vista users should switch to Windows 7 instead of Snow Leopard?

No tough questions were presented in that chart. No “will you support Greenhouse gas regulations even if they triple your electricity and petrol expenses and send more jobs overseas?” No mention of nuclear power, just currently much less large scale cost effective wind and solar power . [Disclaimer -- I considered Penn & Teller's show on nuclear power as a green alternative both entertaining and informative, while I found this chart mostly just entertaining. Informative only in the sense of learning about worst practices in charting, as I believe Jon intended.]


Comment from Jon Peltier
Time: Saturday, November 7, 2009, 10:50 pm

Dale -

A fluff display for a fluff survey? Perhaps you’re right. What I did get out of it, was I used the original large graphic as an opportunity to learn how the OCR piece of MODI (Microsoft Office Document something) worked. And I noticed I had to correct a bunch of misspellings in the text of the graphic. “Goverment” is the one that came up again and again.

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.