You can use LINEST for this. Check Bernard Liengme's site:

http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Terry" wrote in message
...
We have XY (scatter-connected by line) chart.
When I use trendline (polynomial, order of 2) I can ask show up the
equation.

But now we would like extract all number from equation shown in individual
trendline, and put into a separate file, so we can do detail and complex
statistical analysis.
In linear trandline, I can extract number by just computing slope, and
intercept.

Can anyone tell me how to extract number of polynomial equation?