Excel 2007 : waterfall chart

Hi Everyone,

I am building this waterfall chart. I'd like to put conditional color formating to change the vertical bar automatically e.g. if it is positive, the bar color is green and if it is negative the bar color is red.

Can anyone help me

Thanks

Henry

Hello Henry,

you might be interested in the following website: http://www.waterfall-chart.com
It allows you to create a waterfall chart for Excel very easily, and you can edit the colors of the bars as you want! Rather useful tool...
I hope it will help you,


Jacques

Hi, Henry. For auto color you should add data series for each data change case. As for me for one chart seven ones enough. Look at this http://www.fincontrollex.com/?page=p...s&id=1&lang=en. Using this add-in you can see how it make