DataLabels.AutoText Property

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.

  Charts("Chart1").SeriesCollection(1).DataLabels.AutoText = True

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

• DataLabels Object
• DataLabels Object Members