Waterfall chart with variables

[ClaireNewski]

Hi,

I am trying to create a waterfall chart where one of the series has a number of variables.

My waterfall series and example values are:
• Original cost, £3.34m
• IT costs, £195.1k
• Additional BAU, £616.5k
• Cost reduction, -£1m
• Budget, £3.15m

The 'Cost reduction' series has a number of variables which for now I will just call 1, 2, 3 and 4. I want to show these cost reduction as one series, a bit like a stacked chart within the waterfall. I am unable to give you a link to an example due to IT restrictions.

I would like to create this chart without using macros if possible - mainly because I do not understand them and that learning is for another day

Thank you in advance for any help you can give me.

 

[Hui]

Have a read of Chandoo's post:
http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

 

[ClaireNewski]

Have a read of Chandoo's post:
http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

Hi Hui,

Yes, I've used this to create straightforward waterfall charts but struggled when one of the series was a negative value. I'm also not sure how to adapt this to incorporate variables within one of the series.

Any advise?

 

[NARAYANK991]

Hi Claire ,

Have you checked this out ?

http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/

Narayan