PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

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

Archive for Wednesday, August 27th, 2008

Stacked Bar Chart Improvement

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

I compared stacked and clustered charts in Stacked vs. Clustered. Stacked charts seem like they’d be good at showing proportions making up whole quantities, but I showed that the stacks only clearly display the bottom item in the stack and the total stack.
To illustrate this shortcoming, Nicolas Bissantz shows us a stacked bar chart showing [...]

Stacked vs. Clustered

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

Stacked charts are commonly used to compare proportions within a whole. In this post I will concentrate on stacked and clustered vertical column charts, but the arguments hold true for horizontal bar charts, and to some extent for area charts. This table shows some make-believe sales figures for an imaginary company, by quarter and by [...]

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