This documentation is archived and is not being maintained.

Trendlines Interface 

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.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Public Class rendlinesImplementation
	Implements Trendlines
End Class
Dim rendlinesImplementation1 As New rendlinesImplementation()

Public Interface Trendlines
public interface Trendlines
public interface Trendlines

Use the Trendlines method to return the Trendlines collection.

Use the Add method to create a new trendline and add it to the series.

Use Trendlines(index), where index is the trendline index number, to return a single TrendLine object.

The index number denotes the order in which the trendlines were added to the series. Trendlines(1) is the first trendline added to the series, and Trendlines(Trendlines.Count) is the last one added.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms