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)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("000208BD-0000-0000-C000-000000000046")> _
Public Interface Trendlines _
    Inherits IEnumerable
'Usage
Dim instance As Trendlines
[InterfaceTypeAttribute()]
[GuidAttribute("000208BD-0000-0000-C000-000000000046")]
public interface Trendlines : IEnumerable

Remarks

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.

See Also

Reference

Trendlines Members

Microsoft.Office.Interop.Excel Namespace