Skip to content

Latest commit

 

History

History
50 lines (31 loc) · 1.09 KB

Excel.Trendlines.Item.md

File metadata and controls

50 lines (31 loc) · 1.09 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Trendlines.Item method (Excel)
vbaxl10.chm592076
vbaxl10.chm592076
Excel.Trendlines.Item
e2bbc0fc-a618-8c84-f001-c77c0206cbf9
05/18/2019
medium

Trendlines.Item method (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents a Trendlines object.

Parameters

Name Required/Optional Data type Description
Index Optional Variant The index number for the object.

Return value

A Trendline object contained by the collection.

Example

This example sets the number of units that the trendline on Chart1 extends forward and backward. The example should be run on a 2D column chart that contains a single series with a trendline.

With Charts("Chart1").SeriesCollection(1).Trendlines.Item(1) 
 .Forward = 5 
 .Backward = .5 
End With

[!includeSupport and feedback]