View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
CSX321 CSX321 is offline
external usenet poster
 
Posts: 2
Default Resolving Polynomial Trendline Formula for Chart

Thanks, MartinW, that was very helpful!

One thing I don't understand, though, is the formula that is displayed on
the chart for a trend line. Why are the coefficients in the displayed formula
not the same as the ones obtained with LINEST()? I thought maybe the
displayed formula used arbitrarily assigned X values starting with 0, but
that doesn't seem to be the case.

David Reynolds