Trendlines Collection Object

Description

A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

Accessors

Use the Add method to create a new trendline and add it to the series. The following example adds a linear trendline to series one in embedded chart one on the worksheet named "Sheet1."


Worksheets("sheet1").ChartObjects(1).Chart.SeriesCollection(1) _
    .Trendlines.Add type:=xlLinear, name:="Linear Trend"

Use the Trendlines method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Add Method (Trendlines Collection), Item Method.