Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Allows the user to show the percentage value for the data labels on a chart. Read/write Boolean.
Syntax
expression.ShowPercentage
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The chart must first be active before you can access the data labels programmatically.
Example
This example enables the percentage value to be shown for the data labels of the first series on the first chart.
Sub UsePercentage()
ActiveSheet.ChartObjects(1).Activate
ActiveChart.SeriesCollection(1) _
.DataLabels.ShowPercentage = True
End Sub
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.