View Single Post
  #2   Report Post  
Bob Flanagan
 
Posts: n/a
Default

Sige, check out http://www.add-ins.com/cascade_charts.htm

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"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