Trendlines Method

Applies To

Series Object.

Description

Accessor. Returns an object that represents a single trendline (a Trendline object, Syntax 1) or a collection of all the trendlines (a Trendlines object, Syntax 2) for the series.

Syntax 1

object.Trendlines(index)

Syntax 2

object.Trendlines

object

Required. The Series object.

index

Required for Syntax 1. The name or number of the trendline.

Example

This example adds a linear trendline to series one in Chart1.

Charts("Chart1").SeriesCollection(1).Trendlines.Add Type:=xlLinear