Edit

Share via


Trendlines Interface

Definition

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
Implements

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.

Applies to