extracting data touching trendline

[Raz]

Hi,
I have a chart with dates in the horizontal and number values in the
vertical axis. Added a Polynomial trendline with order 2.
Now I will need to extract the data points with both horizontal and vertical
values that are touching the treandline.

Any help, how would this be possible. Thanks in advance.

 

[Bernard Liengme]

Use LINEST as shown at
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
best wishes

 

[Raz]

Thanks For Reply:

I tried as the example explained. but could not get What I wanted.
In this example I get x and b values, and most of them are #N/A.

would you explain a little how do I get x and y values that are on the
trendline. skipping all the other values.

 

[Bernard Liengme]

LINEST as shown at the website gives you the values of a, b, and c in the
polynomial y=ax²+bx+x
Suppose these values are in Q1,R1,T1, and that your first x values is in A2
with y value in B2
To get the first fitted y value use =$Q$1*A2^2+$R$1*A2+$T$1
Copy this formula down the column
Now you have the values that Trendline computes
best wishes