Skip to content

Latest commit

 

History

History
39 lines (24 loc) · 942 Bytes

Excel.Trendline.Period.md

File metadata and controls

39 lines (24 loc) · 942 Bytes
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Trendline.Period property (Excel)
vbaxl10.chm594088
vbaxl10.chm594088
Excel.Trendline.Period
142b675b-8859-a717-1e09-59a8b4000820
05/18/2019
medium

Trendline.Period property (Excel)

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

Syntax

expression.Period

expression A variable that represents a Trendline object.

Example

This example sets the period for the moving-average trendline on Chart1. The example should be run on a 2D 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

[!includeSupport and feedback]