DataLabel Object [Excel 2003 VBA Language Reference]

  • Article
Multiple objects
DataLabel
Multiple objects

Represents the data label on a chart point or trendline. On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object.

Using the DataLabel Object

Use DataLabels(index), where index is the data-label index number, to return a single DataLabel object. The following example sets the number format for the fifth data label in series one in embedded chart one on worksheet one.

Worksheets(1).ChartObjects(1).Chart _
    .SeriesCollection(1).DataLabels(5).NumberFormat = "0.000"

Use the DataLabel property to return the DataLabel object for a single point. The following example turns on the data label for the second point in series one on the chart sheet named "Chart1" and sets the data label text to "Saturday."

With Charts("chart1")
    With .SeriesCollection(1).Points(2)
        .HasDataLabel = True
        .DataLabel.Text = "Saturday"
    End With
End With

On a trendline, the DataLabel property returns the text shown with the trendline. This can be the equation, the R-squared value, or both (if both are showing). The following example sets the trendline text to show only the equation and then places the data label text in cell A1 on the worksheet named "Sheet1."

With Charts("chart1").SeriesCollection(1).Trendlines(1)
    .DisplayRSquared = False
    .DisplayEquation = True
    Worksheets("sheet1").Range("a1").Value = .DataLabel.Text
End With

Properties | Application Property | AutoScaleFont Property | AutoText Property | Border Property | Caption Property | Characters Property | Creator Property | Fill Property | Font Property | HorizontalAlignment Property | Interior Property | Left Property | Name Property | NumberFormat Property | NumberFormatLinked Property | NumberFormatLocal Property | Orientation Property | Parent Property | Position Property | ReadingOrder Property | Separator Property | Shadow Property | ShowBubbleSize Property | ShowCategoryName Property | ShowLegendKey Property | ShowPercentage Property | ShowSeriesName Property | ShowValue Property | Text Property | Top Property | Type Property | VerticalAlignment Property

Methods | Delete Method | Select Method

Parent Objects | Point Object | Trendline Object

Child Objects | Border Object | Characters Object | ChartFillFormat Object | Font Object | Interior Object