You can also use LINEST to get the polynomial coefficients into cells.
Bernard Liengme shows how he
http://www.stfx.ca/people/bliengme/ExcelTips

David Braden wrote the first procedure I know of to extract trendline
coefficients for use in the worksheet. Tushar Mehta made some refinements to
the procedure here (see post 10):
http://groups.google.com/group/micro...6b43d9dc84ebd/

In fact, Tushar has written a detailed chapter on the use of Excel with
regression (including his trendline coefficient procedure):

http://tushar-mehta.com/publish_trai...nalysis/16.htm

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


wrote in message
...
Does anyone know how to extract the trendline formula from a chart
object so that the formula is viewable in a cell?