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
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for