Thank you very much Barb,

I tried it with success but still there was the starting point issue!

Thanks a lot though! Sige

"Barb Reinhardt" wrote in message ...
I've got the following in my spreadsheet

BLANK RED GREEN
Profit 2001 -3.81 =10+B2 =IF($B2<0,-$B2,0) =IF($B20,$B2,0)
Trade P 5.71 =C2+E2-D3 =IF($B3<0,-$B3,0) =IF($B30,$B3,0)
Prime Costs 1.2 =C3+E3-D4 =IF($B4<0,-$B4,0) =IF($B40,$B4,0)
Conversion Costs -0.71 =C4+E4-D5 =IF($B5<0,-$B5,0) =IF($B50,$B5,0)
A&P 1.41 =C5+E5-D6 =IF($B6<0,-$B6,0) =IF($B60,$B6,0)
Other F&S 2.72 =C6+E6-D7 =IF($B7<0,-$B7,0) =IF($B70,$B7,0)
G&A -1.12 =C7+E7-D8 =IF($B8<0,-$B8,0) =IF($B80,$B8,0)
volume effect -15.27 =C8+E8-D9 =IF($B9<0,-$B9,0) =IF($B90,$B9,0)
price effect 11.35 =C9+E9-D10 =IF($B10<0,-$B10,0)
=IF($B100,$B10,0)
Profit 2004 1.49 =C10+E10-D11 =IF($B11<0,-$B11,0)
=IF($B110,$B11,0)


I had to change the "starting point" for your first bar by adding 10 to it,
otherwise, some of the other points would be less than zero and the chart
wouldn't like it. Try plotting a stacked bar chart using the data in
columns A, BLANK, RED and GREEN. You'll also need to use Rob Bovey's XY
Chart Labeler to relabel the chart as the "base" Y value is not where you
want it.

I hope this helps.

"SIGE" wrote in message
om...
Hi There,

I am trying to get the famous waterfall chart to work for my data.
For 2 days now I have been reading and creating dummy series
...
http://www.tushar-mehta.com/excel/ch...fall/index.htm
http://peltiertech.com/Excel/Charts/Waterfall.html
http://peltiertech.com/Excel/Charts/Waterfall2.html
http://peltiertech.com/Excel/Charts/...ies.html#Falls
http://peltiertech.com/Excel/Charts/...ies.html#Fall2
http://peltiertech.com/Excel/Charts/...eAndBelow.html

Jon, Tushar, Frank, ...
Can you please put me on track?
Amount
Profit 2001 -3,81
Trade P 5,71
Prime Costs 1,20
Conversion Costs -0,71
A&P 1,41
Other F&S 2,72
G&A -1,12
volume effect -15,27
price effect 11,35
Profit 2004 1,49

Starting with a negative value and crossing the x-axis is the killer...
:o(
Cheers Sige