Share via


DataLabels.AutoText Property

Excel Developer Reference

True if the object automatically generates appropriate text based on context. Read/write Boolean.

Syntax

expression.AutoText

expression   A variable that represents a DataLabels object.

Example

This example sets the data labels for series one in Chart1 to automatically generate appropriate text.

Visual Basic for Applications
  Charts("Chart1").SeriesCollection(1).DataLabels.AutoText = True
Bb179619.vs_note(en-us,office.12).gif  Note
If you run ?activechart.SeriesCollection(1).datalabels.autotext in the Immediate Window you will receive the following:
Excel 2003: Returns nothing.
Excel 2007: Returns True only when Datalabels have autotext = True, returns False if all Datalabels have autotext = False or some Datalabels have autotext = False.

See Also