Series.Trendlines method (Word)

Returns a collection of all the trendlines for the series.

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

Series Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.