software

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 www.edferrero.com/vba.aspx

Ed Ferrero
Microsoft Excel MVP
www.edferrero.com

gt; I'm creating large data sets with moving average trendlines. I need to
gt; creat
gt; new charts with ONLY the trendlines...maybe in a separate worksheet. Can
gt; the
gt; moving average trendline datapoints be extracted and copied to another
gt; 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:
gt; I'm creating large data sets with moving average trendlines. I need to creat
gt; new charts with ONLY the trendlines...maybe in a separate worksheet. Can the
gt; moving average trendline datapoints be extracted and copied to another sheet?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info