This documentation is archived and is not being maintained.

Period Property [Excel 2003 VBA Language Reference]

Office 2003

Returns or sets the period for the moving-average trendline. Can be a value from 2 through 255. Read/write Long.


This example sets the period for the moving-average trendline on Chart1. 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 Charts("Chart1").SeriesCollection(1).Trendlines(1)
    If .Type = xlMovingAvg Then .Period = 5
End With

Applies to | Trendline Object

See Also | Type Property