Series.Trendlines method (Word)
Returns a collection of all the trendlines for the series.
expression A variable that represents a 'Series' object.
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
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.