Waterfall Graph

[Sirpeterjones]

Hi Team,
Does anyone know how to create this graph in excel please...

 

[Jeffrey Mahoney]

Waterfall Chart Automated

 

[Jeffrey Mahoney]

You'll have to add the 11% bridge manually

 

[Sirpeterjones]

Thanks for this Jeff, what the example is missing is 6th BAR - "Adjusted Baseline" which is at the bottom. I am able to create a waterfall chart in the new excel versions relatively easily, however this additional Blue bar is proving quite difficult. This chart was created in powerpoint using "Thinkcell", I just need to find a way to do that same thing in excel