Hello all,

I have been banging my head against the wall forever on this one...

I have a scatter plot X,Y graph in my spreadsheet. The X axis is dates, and
the Y, dollar figures (Value over time). The plotting is fine, however I have
a constant line (cost) which at some point the values will cross. I need to
get Excel to draw a vertical line, or at the very least tell me the figure at
which this happens.

I know of the "INTERSECT" and "LINEST" functions, however they are just
returning unusable decimals, I'm guessing due to having dates on one axis.

I am using Excel 2007 Please Help!
Thank You!