Share via

Point.HasDataLabel Property

  • Article
Excel Developer Reference

True if the point has a data label. Read/write Boolean.

Syntax

expression.HasDataLabel

expression   A variable that represents a Point object.

Example

This example turns on the data label for point seven in series three in Chart1, and then it sets the data label color to blue.

Visual Basic for Applications 
  With Charts("Chart1").SeriesCollection(3).Points(7)
    .HasDataLabel = True
    .ApplyDataLabels Type:=xlValue
    .DataLabel.Font.ColorIndex = 5
End With

See Also