How can i get polinomial trendline constants in a worksheet?

[Rolocors]

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.

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.