Series.Trendlines method (Word)

Returns a collection of all the trendlines for the series.


expression.Trendlines (Index)

expression A variable that represents a 'Series' object.

Return value

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


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.