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