Skip to content

Latest commit

 

History

History
51 lines (31 loc) · 1.12 KB

Excel.SeriesCollection.Item.md

File metadata and controls

51 lines (31 loc) · 1.12 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
SeriesCollection.Item method (Excel)
vbaxl10.chm580077
vbaxl10.chm580077
Excel.SeriesCollection.Item
9a1f393b-e0b0-0887-b76e-471982ae0414
05/14/2019
medium

SeriesCollection.Item method (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents a SeriesCollection object.

Parameters

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

Return value

A Series 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.Item(1).Trendlines.Item(1) 
 .Forward = 5 
 .Backward = .5 
End With

[!includeSupport and feedback]