Stacked Waterfall Chart

[AlexHanmer]

Hi,

I wonder if anybody can help. I am trying to build a waterfall chart showing some impact to revenue. I can build a waterfall chart but the issue is that I need 2 elements to it. So say I have a green bar showing growth of revenue because of volume, I need to split that bar into 2 (store sales/internet sales).

Can anyone help?

Thanks,
Alex

 

[GlennUK]

How are you building your waterfall chart? If you are using stacked columns I don't see what your problem is.

 

[AlexHanmer]

when I add a new row, it just adds a new bar as opposed to splitting the bar I am on

 

[GlennUK]

Show your data.

And tell how you are adding the new row to the chart.

What version of Excel?

 

[AlexHanmer]

Hi

so If i have a starting point of 181. I want the next bar's net position to be 30, by going up 45 for store, and down 15 for internet. the second bar then needs to start at the 30 point and go down 10 for store


how do I attach something to this thread?

 

[GlennUK]

I see what you mean now.

No, you can't attach a file to this thread, but you can post sections of your sheet using Excel Jeanie:
http://www.excel-jeanie-html.de/index.php?f=1

In any case, is this any use:

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

?