Series.ApplyDataLabels (PowerPoint)
Applies data labels to a series.
The Type parameter can be one of the following xlDataLabelsType constants:
ApplyDataLabels (Type, LegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator)
ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).ApplyDataLabels
Arguments
Optional arguments
The following arguments are optional
Type (XlDataLabelsType) - The type of data label to apply.
Possible values are
| xlDataLabelsShowBubbleSizes | Show the size of the bubble in reference to the absolute value. |
| xlDataLabelsShowLabel | The category for the point. |
| xlDataLabelsShowLabelAndPercent | The percentage of the total, and the category for the point. Available only for pie charts and doughnut charts. |
| xlDataLabelsShowNone | No data labels. |
| xlDataLabelsShowPercent | The percentage of the total. Available only for pie charts and doughnut charts. |
| xlDataLabelsShowValue | The default value for the point (assumed if this argument is not specified). |
LegendKey (String) - True to show the legend key next to the point. The default is False.
AutoText (Boolean) - True if the object automatically generates appropriate text based on content.
HasLeaderLines (Boolean) - For the Chart and Series objects, True if the series has leader lines.
ShowSeriesName (Boolean) - True to enable the series name for the data label; otherwise, False.
ShowCategoryName (Boolean) - True to enable the category name for the data label; otherwise, False.
ShowValue (Boolean) - True to enable the value for the data label; otherwise, False.
ShowPercentage (Boolean) - True to enable the percentage for the data label; otherwise, False.
ShowBubbleSize (Boolean) - True to enable the bubble size for the data label; otherwise, False.
Separator (String) - The separator for the data label.