Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Trendlines Interface
Collapse the table of content
Expand the table of content

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 microsoft.office.interop.excel.dll)

'Usage
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

Community Additions

ADD
Show:
© 2015 Microsoft