Expand Minimize

Period Property

Returns or sets the period for the moving-average trendline. Read/write Long.

This example sets the period for the moving-average trendline. The example should be run on a 2-D column chart with a single series that contains 10 data points and a moving-average trendline.

With myChart.SeriesCollection(1).Trendlines(1) 
 If .Type = xlMovingAvg Then .Period = 5 
End With

Community Additions

ADD
Show:
© 2014 Microsoft