Constant | Description |
xlDataLabelsShowNone | No data labels. |
xlDataLabelsShowValue | Value for the point (assumed if this argument isn't specified). |
xlDataLabelsShowPercent | Percentage of the total. Available only for pie charts and doughnut charts. |
xlDataLabelsShowLabel | Category for the point. This is the default value. |
xlDataLabelsShowLabelAndPercent | Percentage of the total, and category for the point. Available only for pie charts and doughnut charts. |
Charts("Chart1").SeriesCollection(1). _
ApplyDataLabels Type:=xlDataLabelsShowLabel