Edit

XlDataLabelsType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Core
Assembly:
office.dll

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.

public enum class XlDataLabelsType
public enum XlDataLabelsType
type XlDataLabelsType = 
Public Enum XlDataLabelsType
Inheritance
Enum
XlDataLabelsType

Fields

xlDataLabelsShowBubbleSizes 6

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.
xlDataLabelsShowLabel 4

You should access and use this enumeration from the Excel primary interop assembly (PIA). Category for the point.
xlDataLabelsShowLabelAndPercent 5

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.
xlDataLabelsShowNone -4142

You should access and use this enumeration from the Excel primary interop assembly (PIA). No data labels.
xlDataLabelsShowPercent 3

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.
xlDataLabelsShowValue 2

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).

Applies to