Chart.ApplyDataLabels Method
Syntax
expression.ApplyDataLabels(Type, IMsoLegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator)
expression An expression that returns a Chart object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Type | Optional | Variant | The type of data label to apply. |
| IMsoLegendKey | 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. |
Example
This example applies category labels to series one in Chart1.
| Visual Basic for Applications |
|---|
|