Table of contents
Collapse the table of content
Expand the table of content

Chart.ApplyDataLabels Method (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Applies data labels to all the series in a chart.


expression. ApplyDataLabels( Type, LegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator )

expression A variable that represents a Chart object.


NameRequired/OptionalData TypeDescription
TypeOptionalXlDataLabelsTypeOne of the enumeration values that specifies the type of data label to apply.
LegendKeyOptionalVariantTrue to show the legend key next to the point. The default is False.
AutoTextOptionalVariantTrue if the object automatically generates appropriate text based on content.
HasLeaderLinesOptionalVariantFor the Chart and Series objects, True if the series has leader lines.
ShowSeriesNameOptionalVariantTrue to enable the series name for the data label; otherwise, False.
ShowCategoryNameOptionalVariantTrue to enable the category name for the data label; otherwise, False.
ShowValueOptionalVariantTrue to enable the value for the data label; otherwise, False.
ShowPercentageOptionalVariantTrue to enable the percentage for the data label; otherwise, False.
ShowBubbleSizeOptionalVariantTrue to enable the bubble size for the data label; otherwise, False.
SeparatorOptionalVariantThe separator for the data label.


The Type parameter can be one of the following XlDataLabelsType constants:

  • xlDataLabelsShowBubbleSizes ?The bubble size for the data label.

  • xlDataLabelsShowLabelAndPercent ?The percentage of the total, and the category for the point. Available only for pie charts and doughnut charts.

  • xlDataLabelsShowPercent ?The percentage of the total. Available only for pie charts and doughnut charts.

  • xlDataLabelsShowLabel ?The category for the point.

  • xlDataLabelsShowNone ?No data labels.

  • xlDataLabelsShowValue ?(Default) The value for the point (assumed if this argument is not specified).


Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

The following example applies category labels to the first series of the first chart in the active document.

With ActiveDocument.InlineShapes(1)
    If .HasChart Then
        .Chart.SeriesCollection(1). _
            ApplyDataLabels Type:=xlDataLabelsShowLabel
    End If
End With

Note If you use a string for the Separator parameter, you will get a string as the separator. If you use xlDataLabelSeparatorDefault (= 1), you will get the default data label separator, which is either a comma or a newline, depending on the data label.When a value of 1 is returned, it indicates that the user has not changed the default separator, which is a comma (,). You can also pass a value of 1 to change the separator back to the default separator.The chart must first be active before you can access the data labels programmatically; otherwise, a run-time error occurs.

See also


Chart Object

© 2018 Microsoft