Sorry, had one other question. You mentioned needing to fit a physical model
to my data. What does this mean?
"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?