adding trendline into data-column

[Inge Jonckheere]

After adding a trendline (moving average), I woudl like
to add the values of the trendline into a column..How can
I do that??

 

[Jerry W. Lewis]

The chart trendline option is for a simple moving average, e.g. with
period 3, the plotted point is the average of the current and previous
two points. Just use the average function and copy the formula down.

For an exponentially weighted moving average (does not seem to be among
the chart options) see
http://groups.google.com/groups?selm=409CD102.6050009@no_e-mail.com

Jerry