Period Property

Applies To

Trendline Object.

Description

Returns or sets the period of the trendline (applies only if this is a moving average trendline; its Type property must be xlMovingAvg). Read-write.

See Also

Type Property.

Example

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