On Wed, 16 Jan 2008, in microsoft.public.excel.charting,
sauza311 said:

The problem lies when Prior Year and Plan Base numbers are negative.
Instead of flowing through the chart from row item to row item and beginning
where the base of the previous one left off, all of the columns start at $0
(X axis) and extend up the amount they are suppossed to. Usually each new
row item begins at a different number or point on the graph. When the
initial numbers off which the original base point is based are negative, the
graph looks completely wack. I need to try to figure out a way to start the
next item where the previous one left off.

It sounds like you're saying "I have a waterfall chart that goes wrong
when it crosses the X axis". If so, have a look at this page on Jon
Peltier's site for ways to fix the problem:

http://peltiertech.com/Excel/Charts/...lcrossing.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.