polynomial fit coefficients displayed to an arbitrary precision?

Z

z.entropic

How one can increase the precision with which polynomial fit coefficients are displayed on Excel charts? The default values are seriously rounded and cannot be used to obtain the original curve if the numbers are really small or large

z.entropic
 
R

Ron Rosenfeld

How one can increase the precision with which polynomial fit coefficients are displayed on Excel charts? The default values are seriously rounded and cannot be used to obtain the original curve if the numbers are really small or large.

z.entropic
Click to expand...

Right click on the equation
Format Data Labels
Number/Number Decimal Places: however many you need


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Polynomial Treandline Coefficients 6
Excel: How automatically read coefficients from polynomial fit? 1
using polynomial trendline equations 2
Increaseing Precision in polynomial trendline equations 7
Polynomial fit coefficients without a graph? 2
How to put coefficients of trend line into spreadsheet? 5
Precision as displayed problems 1
using linest to generate 3rd order polynomial coefficients 4

Top