Series.ApplyDataLabels Method
| Excel Developer Reference |
Applies data labels to a series.
Syntax
expression.ApplyDataLabels(Type, LegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator)
expression A variable that represents a Series object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Type | Optional | XlDataLabelsType | The type of data label to apply. |
| LegendKey | Optional | Variant | True to show the legend key next to the point. The default value is False. |
| AutoText | Optional | Variant | True if the object automatically generates appropriate text based on content. |
| HasLeaderLines | Optional | Variant | For the Chart and Series objects, True if the series has leader lines. |
| ShowSeriesName | Optional | Variant | Pass a boolean value to enable or disable the series name for the data label. |
| ShowCategoryName | Optional | Variant | Pass a boolean value to enable or disable the category name for the data label. |
| ShowValue | Optional | Variant | Pass a boolean value to enable or disable the value for the data label. |
| ShowPercentage | Optional | Variant | Pass a boolean value to enable or disable the percentage for the data label. |
| ShowBubbleSize | Optional | Variant | Pass a boolean value to enable or disable the bubble size for the data label. |
| Separator | Optional | Variant | The separator for the data label. |
Remarks
| XlDataLabelsType can be one of these XlDataLabelsType constants. |
| xlDataLabelsShowBubbleSizes. The bubble size for the data label. |
| xlDataLabelsShowLabelAndPercent. Percentage of the total, and category for the point. Available only for pie charts and doughnut charts. |
| xlDataLabelsShowPercent. Percentage of the total. Available only for pie charts and doughnut charts. |
| xlDataLabelsShowLabel. Category for the point. |
| xlDataLabelsShowNone. No data labels. |
| xlDataLabelsShowValue. default. Value for the point (assumed if this argument isn't specified). |
Example
This example applies category labels to series one in Chart1.
| Visual Basic for Applications |
|---|
|
See Also