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. |
myChart.SeriesCollection(1). _
ApplyDataLabels Type:=xlDataLabelsShowLabel