View Single Post
  #1   Report Post  
SIGE
 
Posts: n/a
Default waterfall chart ... once again ...

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