XlDataLabelsType enumeration

Office 2013 and later

Other Versions

You should access and use this enumeration from the Excel primary interop assembly (PIA).

Specifies the type of data label to apply. The default is typically xlDataLabelsShowValue.

Namespace: Microsoft.Office.Core
Assembly: office (in office.dll)

Syntax

No code example is currently available or this language may not be supported.

	Member name	Description
	xlDataLabelsShowNone	You should access and use this enumeration from the Excel primary interop assembly (PIA). No data labels.
	xlDataLabelsShowValue	You should access and use this enumeration from the Excel primary interop assembly (PIA). Value for the point (assumed if this argument isn't specified).
	xlDataLabelsShowPercent	You should access and use this enumeration from the Excel primary interop assembly (PIA). Percentage of the total. Available only for pie charts and doughnut charts.
	xlDataLabelsShowLabel	You should access and use this enumeration from the Excel primary interop assembly (PIA). Category for the point.
	xlDataLabelsShowLabelAndPercent	You should access and use this enumeration from the Excel primary interop assembly (PIA). Percentage of the total, and category for the point. Available only for pie charts and doughnut charts.
	xlDataLabelsShowBubbleSizes	You should access and use this enumeration from the Excel primary interop assembly (PIA). Show the size of the bubble in reference to the absolute value.