Waterfall charts

[Guest]

Hi, I currently use waterfall charts and I was wondering if it's possible to
have a stacked bar chart within the waterfal chart. I guess what I am trying
to ask is: Is it possible in the waterfall chart in the columns to then have
the column broken down into different colors represening the numbers making
up the whole column similar to a stacked bar chart?

I would appreciate if anyone knows how to do this.

Thanks,
Sarah

 

[Jon Peltier]

Since you need to use a stacked column in Excel to make a waterfall chart,
you could simply use multiple columns for each section of the waterfall
chart instead of just one. For example, in this simple example:

http://peltiertech.com/Excel/Charts/Waterfall.html

Instead of columns D and E for "Minus" and "Plus", you could insert extra
columns to allow for "Minus A", "Plus A", "Minus B", "Plus B", etc. In fact,
this example does much the same thing:

http://peltiertech.com/Excel/Charts/Waterfall2.html

- Jon

 

[Jon_Peltier]

I know this is an old thread, but people still find it and follow it to my web site.

I've consolidated and updated the Waterfall/Bridge Chart articles, and the new article is Excel Waterfall Charts (Bridge Charts).