Think Before You Stack

June 24th, 2009

I hate to beat this to death, but I continue to see charts like the one below featured in excellent periodicals like BusinessWeek.  As I said in a previous post, I really dislike stacked bar charts, ESPECIALLY when time is on the x-axis.  To help illustrate my point, here are a few questions:

1) How much did the Subprime (yellow) dollars change from month to month or between any points?

2) Is there even a value for Subprime after about March 2013?

3) How many times do you have to reference the legend to figure out which color is what label?

The only value that is easy to visualize and analyze is the Agency data that is in black and the first data series.  Beyond Agency, this data visualization is useless.  I tried to get the data to make a better chart, but couldn’t locate it.  Instead I ask that you visualize 7 lines in a line chart, one for each value and the 7th one for the total.  Using that chart, you could easily see the trend in each value and also the overall change. 

Yes, this chart is colorful and caught my eye, but it’s also worthless. 

stacked bars

[source]

Below is another example using similar data where the data visualization is completely ineffective. 

CS_Default

[source]

Excel Formulas From a Microsoft MVP!

June 9th, 2009

Heat Map for Excel

June 4th, 2009

Stephen Few On New Data Visualization Book [Interview]

May 21st, 2009

Excel and Project Gemini

May 7th, 2009

Where To Draw The Line: Line Graph vs. Area Chart

May 4th, 2009

Who Ate My Slice? [Chart Review]

April 13th, 2009

Liquidations – Map Visualization [Chart Review]

April 7th, 2009

Support Analytics – Best of 2009 Q1

April 1st, 2009

New Stephen Few Book Update

March 30th, 2009