Series.Trendlines Method (Word)

Returns a collection of all the trendlines for the series.

Version Information

Version Added: Word 2007

Syntax

expression .Trendlines(Index)

expression A variable that represents a Series object.

Return Value

A Trendlines object that represents all the treadlines for the series.

Example

The following example adds a linear trendline to series one for the first chart in the active document.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.SeriesCollection(1).Trendlines.Add Type:=xlLinear 
 End If 
End With

See Also

Concepts

Series Object

Series Object Members