Edit

Share via

DataLabels.AutoText property (Excel)

  • Article

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 on 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'll receive the following:

  • Excel 2003: Returns nothing.
  • Excel 2007 and later: Returns True only when all DataLabels have AutoText = True, returns False if all DataLabels have AutoText = False or some DataLabels have AutoText = False.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.