Jane,

It is possible that NONE of your data might actually fit the line.
That's the idea with trendlines, we have a discrete set of (x,y) pairs
and we try to find a continuous function that best fits them.

One thing you can do is use a column next to your dependent variable
and plot the function that you get from the trendline using your
independent variable column in place of x (e.g. =0.01*A2+7890)

Once you copy this you can see which values of x (if any) match the
value the trend function produces.

HTH
Kostis Vezerides


macropod wrote:
Hi Jane,

If you format the trendline to display its equation on the chart, that's the
formula you need.

Cheers

--
macropod
[MVP - Microsoft Word]


"Jane" wrote in message
...
I have a column of data for which I have created a scatter chart and then
sorted in descending order after which I added a trendline. I can hover
my
cursor to see the data point at which the trendline intersects my line of
data but.....

I need a formula that gives me the exact data point at which the trendline
interesects the data.

thank you in advance! Jane