View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew
 
Posts: n/a
Default Getting values from a trend line

I've got a line with 52 data points for which I've put in a Polynomial Trend
Line degree 6 to provide a smooth profile.

The next stage that I want to do is to work out what the values are of the
Trend Line. Currently I display the equation on the Chart, copy it, paste
into a cell and adjust the format accordingly. Very long-winded, and the
process needs to be re-done every time the data is updated.

There must be an easier way. Something that involves a direct link and no
copy and pasting. Any ideas?