or is this my answer? R2 = 0.9003 so the exact point that intersects is
90.03% (I need to express my result as a %)
thansk! jane

"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