Waterfall charts

[Sclapham101]

I have been trying to use the waterfall chart template. It's great for positive numbers but when I enter a negative number the chart goes haywire. Can anyone please help? Thanks

 

[Hui]

Sclapham101


Firstly, Welcome to the Chandoo.org forums.


You need to add another set of series to cater for the negatives

Have a read of: http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/

 

[Krishnakumar]

another one..


http://www.excelfox.com/forum/f13/excel-dynamic-waterfall-chart-317/

 

[sdsurzh]

Hi,


Please try.


http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/


Thanks,

Suresh Kumar S

 

[Jon Peltier]

Actually, my article that Hui cited does not require an extra series to account for negatives. The up/down bars handle values that span the horizontal axis without any special consideration, and is the easiest and most reliable method to create these charts that I've ever swiped from someone else.


Chandoo's page (cited by Suresh) does not handle negative values. The proposal by Krishnakumar requires complicated defined names and uses macros to maintain the charts.