Edit

Chart.ApplyDataLabels method (PowerPoint)

  • Article

Applies data labels to all the series in a chart.

Syntax

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

expression A variable that represents a Chart object.

Parameters

Name Required/Optional Data type Description
Type Optional XlDataLabelsType One of the enumeration values that specifies the type of data label to apply. Can be one of the xlDataLabelsType constants.
LegendKey Optional Variant True to show the legend key next to the point. The default 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 True to enable the series name for the data label; otherwise, False.
ShowCategoryName Optional Variant True to enable the category name for the data label; otherwise, False.
ShowValue Optional Variant True to enable the value for the data label; otherwise, False.
ShowPercentage Optional Variant True to enable the percentage for the data label; otherwise, False.
ShowBubbleSize Optional Variant True to enable the bubble size for the data label; otherwise, False.
Separator Optional Variant The separator for the data label.

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.