thanks for the response. I actually found that site a couple of hours ago.
Unfortunately for me, my numbers start negative and I have to use a different
series (Last Year's Number) as one of my endpoints. I tried to follow his
example but it didn't work for me. I have logically figured out what's going
wrong but still haven't found a solution. At first I tried putting ABS
values around all of the negatives, but it still didn't come out right. The
problem with the examples I found on the Internet is that they don't have
that extra BS line item (maybe if i took it out it would be easier? hmm...)
and everything goes crazy when it starts negative. Yes, the problem is that
each successive new column always starts on the Xaxis at $0 and doesn't begin
where it is suppossed to. If you think of a logical way to do these things
let me know.
Thanks
"Del Cotter" wrote:

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.