View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
John1791 John1791 is offline
external usenet poster
 
Posts: 7
Default Trendline Significant Values

I am trying to work with trendlines, and I can match my data with a
polynominal trendline. The plotted trendline matches the data points very
closely, but when I apply the formula generated to actual data, my projected
values are way off. I believe the problem is that the displayed formula is
rounding constants off and not displaying to the number of significant
figures required to generate a workable formula.

Are there any ways to change any settings to allow Excel to display more
figures in the diplayed trendline formulas?

Thank you in advance.