Rediger

Del via

XlDataLabelsType enumeration (Excel)

  • Artikkel

Specifies the type of data label to apply.

Name Value Description
xlDataLabelsShowBubbleSizes 6 Show the size of the bubble in reference to the absolute value.
xlDataLabelsShowLabel 4 Category for the point.
xlDataLabelsShowLabelAndPercent 5 Percentage of the total, and category for the point. Available only for pie charts and doughnut charts.
xlDataLabelsShowNone -4142 No data labels.
xlDataLabelsShowPercent 3 Percentage of the total. Available only for pie charts and doughnut charts.
xlDataLabelsShowValue 2 Default value for the point (assumed if this argument is not specified).

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.