Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Waterfall Chart | Charts and Charting in Excel | |||
Waterfall Charts - Automation | Charts and Charting in Excel | |||
waterfall charts | Charts and Charting in Excel | |||
3D Waterfall | Charts and Charting in Excel | |||
waterfall chart ... once again ... | Charts and Charting in Excel |