DataLabels.Item Method

  • Article
Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a DataLabels object.

Parameters

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

Return Value
A DataLabel object contained by the collection.

Example

This example sets the number format for the fifth data label in series one in embedded chart one on worksheet one.

Visual Basic for Applications 
  Worksheets(1).ChartObjects(1).Chart _
    .SeriesCollection(1).DataLabels.Item(5).NumberFormat = "0.000"

See Also