How can i get polinomial trendline constants in a worksheet?
 

Hi,

I have a polinomial fit graph, so I only have the "polinomial fit function"
in the graph ..as a text, but I'd like to have the constants and the
Pearson's value automatically linked in the worksheet.

Could you help me?
Thanks in advance,
Rolo.

Use LINEST to get the coefficients of a polynomial fit into cells
See example at www.stfx.ca/people/bliengme/ExcelTips
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rolocors" wrote in message
...
Hi,

I have a polinomial fit graph, so I only have the "polinomial fit
function"
in the graph ..as a text, but I'd like to have the constants and the
Pearson's value automatically linked in the worksheet.

Could you help me?
Thanks in advance,
Rolo.