Series.HasDataLabels Property

  • Article
Excel Developer Reference

True if the series has data labels. Read/write Boolean.

Syntax

expression.HasDataLabels

expression   A variable that represents a Series object.

Example

This example turns on data labels for series three in Chart1.

Visual Basic for Applications 
  With Charts("Chart1").SeriesCollection(3)
    .HasDataLabels = True
    .ApplyDataLabels Type:=xlValue
End With

See Also