Item Property (Charts Collection)

Applies To

Charts collection object.

Description

Returns a single Chart object from a Charts collection.

Syntax

expression.Item(Index)

expression An expression that returns a Charts object.

Index Required Variant. The name or index number of the chart.

Example

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

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