Use LINEST as demonstrated in
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"M.R." wrote in message
...
I need the coefficients from a polynomial trendline in a chart for further
calculations in excel. Is there a function in excel to get it
automatically
or do I need to manually type the values displayed in the chart into my
worksheet?