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.

Hide Your Data in an Interactive Onion Chart

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

A reader named Martin suggested that I take a look at The Slate Bailout Guide, which sported a concentric set of rings purporting to be a chart. It was interactive and all, very slick. The graphic contained data regarding the economic bailout efforts by the US government over the past year. But it tried to do too much, and ended up being confusing.

Onion-like chart from Slate

The chart had a timeline along the bottom, but it was unlinked from the values in the rings. It almost was linked like a legend, but colors in the chart were repeated for multiple items. When you mouse over a ring, or a box along the timeline, or entries in a legend below the chart, a box pops up to provide additional information. Nice, I guess, but you can’t easily compare information between different rings.

Mousing over the Slate chart

I did a quick check using a stacked bar chart to show that the rings protrayed data according to thickness, not by area. The authors of the article compared their chart to an onion, so volume may even have been a better analogue for value, except that would have been even more difficult to interpret. The stacked column chart is probably a better way to show the cumulative total of the bailout. My stacked column chart could be made more compact, but it still is much smaller (and therefore information-dense) than the onion chart above.

Stacked columns are better

In all of my charts, the dollar axis labels show Billions of dollars. Wow, it would only take a few million to bail me out!

I’ve extended the stacked column chart to display both committed and spent funds in a single view, while the interactive chart required the user to interactively hide one view and show the other. It’s still a difficult chart type to interpret.

Stacked columns are better

I used a bar chart to show the bailout items in chronological order. The bars are not stacked, but instead the Spent columns are drawn in front of the Committed columns, giving a thermometer-like %-complete effect.

Stacked bars listed by date

The items are listed chronologically in the chart above, but it is impractical to show bars or columns along a proportional time axis. This causes the chart’s message to be choppy. I’d like to see the items ranked according to their dollar values, so I can ignore the small values that are (relatively) insignificant.

Stacked bars listed in descending order of size

It would be nice to see a timeline of the bailout events, though, so I built a step chart. This gives a more complete picture: there was a bump a year ago, and some small additions, but not much from mid-Spring to mid-Fall, when activity took off, leading to the hockey stick behavior at the end of the year.

Step chart showing timeline of bailout events

The Slate chart tries to put too much into a single view. This causes the reader to miss information, by the mere fact of not being able to see more than a bite at a time. All of the information in the interactive pop-up windows should be placed in a table adjacent to the chart, so the reader can read from multiple fields at a time, comparing items without having to play a game of Concentration to remember which pop-up corresponds to which ring. And the rings have to go. It’s impossible to compare values between rings, and it’s impossible to compare spent funds vs. committed funds. The ring charts take up much more space than their scant data justifies.

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.

Comments


Comment from db
Time: Monday, December 22, 2008, 7:18 am

nice work, Jon


Comment from Tim Mayes
Time: Monday, December 22, 2008, 3:41 pm

Agreed, nice job Jon. I really like that step chart at the end. Very informative to see both the magnitudes and timing in the chart.


Comment from Zhirui
Time: Monday, December 22, 2008, 6:03 pm

Looks good, Jon. I like the step chart, but I’m not sure how you’d indicate what has already been spent. You could add a second step, but it wouldn’t tell you which pot o’ money it came from. Maybe “% spent” labels after each bailout?

One question… Are you sure the axis is in trillions? It looks like billions because you have the “,000″ on each number.


Comment from Jon Peltier
Time: Monday, December 22, 2008, 9:17 pm

Hi Zhiriu -

Good catch, I did mean Billions on the axes. When numbers get that high, I guess I’m no smarter than Congress.

I thought about a second step chart to show spending, or adding a second series to the first step chart. It would be very messy, though. For the allotments, there is a vertical step because the allocation is made in one moment, while the actual payments are spread out over time. I doubt anyone even knows what this looks like.

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.