Waterfall Bridge Chart

[overbomb]

Excel forum - waterfall bridge column chart.xlsx

Hello,

i need to replicate (update) a chart for which I do not have the source document, therefore I need to recreate it as figs have updated

would be great if someone could have a look and help!?

I've tried it but I'm obviously missing something but not quite sure what?

Thanks, Maddy

[Steve=True]

Hi Overbomb.

Check out the steps below for your waterfall bridge column chart and a sample file with your solution.

Here is how it is made:

1) One column holds your starting amount as the first row and your ending amount as your last row
2) In between, you need to stagger the data into another 3 columns. 1 for the stacked column No Fill series, 1 for Green increases and 1 for Red decreases
3) Create a stacked column chart
4) Change your fill colors for Red decrease and Green increase series
5) Decrease the column gap to Zero
6) Add Labels
7) Remove Legend

Here is the attachment: Waterfall bridge stacked column chart.xlsx

Please let me know if this helps.

Steve=True