Trendlines Method
Applies To
Series object.
Description
Returns an object that represents a single trendline (a Trendline object, Syntax 1) or a collection of all the trendlines (a Trendlines collection, Syntax 2) for the series.
Syntax 1
object.Trendlines(Index)
Syntax 2
object.Trendlines
object Required. The Series object.
Index Optional Variant. The name or number of the trendline.
Example
This example adds a linear trendline to series one.
myChart.SeriesCollection(1).Trendlines.Add Type:=xlLinear