Edit

Share via

XlDataLabelsType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the type of data label to apply.

public enum class XlDataLabelsType
public enum XlDataLabelsType
Public Enum XlDataLabelsType
Inheritance
Enum
XlDataLabelsType

Fields

Name Value Description
xlDataLabelsShowNone -4142

No data labels.
xlDataLabelsShowValue 2

default. Value for the point (assumed if this argument isn't specified).
xlDataLabelsShowPercent 3

Percentage of the total. Available only for pie charts and doughnut charts.
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.
xlDataLabelsShowBubbleSizes 6

Show the size of the bubble in reference to the absolute value.

Applies to