Waterfall charts
 

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

Waterfall charts
 

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, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Keges" wrote in message
...
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