Skip to content

Latest commit

 

History

History
46 lines (29 loc) · 997 Bytes

Excel.Charts.Item.md

File metadata and controls

46 lines (29 loc) · 997 Bytes
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Charts.Item property (Excel)
vbaxl10.chm217076
vbaxl10.chm217076
Excel.Charts.Item
792e3562-7d70-4356-7072-fa09cb40ec47
04/20/2019
medium

Charts.Item property (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents a Charts object.

Parameters

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

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

[!includeSupport and feedback]