Once again, you can to the rescue

Hope all is well

Joan

"Jon Peltier" wrote:

Hi Sige -

After dozens of requests from various readers of my site, I've added a page showing
how to combine the "Waterfall Charts" and "Stacked Column Charts that Cross the X
Axis" techniques:

Waterfall Charts that Cross the X Axis
http://peltiertech.com/Excel/Charts/...lcrossing.html

The sample data is closely related to the data in your post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


SIGE wrote:

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