Bernard Liengme has a nice tutorial on the use of LINEST to compute a poly
fit in a worksheet:

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

Tushar Mehta has a more comprehensive treatment:

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
_______



"jlm@mca" wrote in message
...
I don't have the actual equation, only the label on the chart, which is
just
text. How can I get the actual equation?

"Jon Peltier" wrote:

1. Select the trendline equation, then use the Increase Decimal buttons
on
the formatting toolbar to add decimal digits, or press Ctrl+1 (numeral
one)
and click on the Number tab, and select a Scientific format with 15
places.

2. A 6th order poly fit is generally not well suited to fitting a curve
unless you are only looking to make the chart look pretty. As Martin
Brown
stated in another thread just an hour ago:

You really need to fit a physical model to your data rather than the
highest
order polynomial available.

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


"jlm@mca" wrote in message
...
I used a 6th degree polynomial trendline to smooth a curve on a chart.
I
selected the option for printing the trendline formula on the chart so
I
could use it in my calculations, but the numbers in the equation are
rounded
so that I don't get the right results. Is there any way that I can
output
the equation with more significant figures shown?