XlDataLabelsType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 XlDataLabelsTypepublic enum XlDataLabelsTypetype XlDataLabelsType = Public Enum XlDataLabelsType- Inheritance
-
XlDataLabelsType
Fields
| Name | Value | Description |
|---|---|---|
| xlDataLabelsShowNone | -4142 | You should access and use this enumeration from the Excel primary interop assembly (PIA). No data labels. |
| 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). |
| 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. |
| 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. |
| 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. |