Trendlines Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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.

public interface class Trendlines : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("000208BD-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Trendlines : System.Collections.IEnumerable

Public Interface Trendlines
Implements IEnumerable

Attributes

GuidAttribute InterfaceTypeAttribute

Implements

IEnumerable

Remarks

Use the Trendlines(Object) method to return the Trendlines collection.

Use the Add(XlTrendlineType, Object, Object, Object, Object, Object, Object, Object, Object) 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.

Properties

Application	Returns an Application object that represents the Microsoft Excel application.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Parent	Returns the parent object for the specified object.

Methods

_Default(Object)	Reserved for internal use.
Add(XlTrendlineType, Object, Object, Object, Object, Object, Object, Object, Object)	Creates a new trendline. Returns a Trendline object.
GetEnumerator()
Item(Object)	Returns a single object from a collection.