how do I extract the moving average trendline point data?

I'm creating large data sets with moving average trendlines. I need to creat
new charts with ONLY the trendlines...maybe in a separate worksheet. Can the
moving average trendline datapoints be extracted and copied to another sheet?

Hi bobb,

A moving average is calculated fairly easily - lets' assume you want a
13-point MA to smooth monthly data, you just need to average all values for
the current month and 6 months above and below the current month.
eg if data is in column A enter =AVERAGE(A1:A12) in cell B7 and copy down.

A better way to smooth a time series is with a weighted moving average
(called a filter) you can download an add-in to calculate the Henderson
Filter from my web site at http://www.edferrero.com/vba.aspx

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

> I'm creating large data sets with moving average trendlines. I need to
> creat
> new charts with ONLY the trendlines...maybe in a separate worksheet. Can
> the
> moving average trendline datapoints be extracted and copied to another
> sheet?

Hi,

Perhaps you could simply format the data series that the trendlines are
based upon to have no line or fill/markers. You can also, if required,
delete the series entries from the legend.

Cheers
Andy

bobb wrote:
> I'm creating large data sets with moving average trendlines. I need to creat
> new charts with ONLY the trendlines...maybe in a separate worksheet. Can the
> moving average trendline datapoints be extracted and copied to another sheet?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info