ShowPercentage Property [Excel 2003 VBA Language Reference]

True to display the percentage value for the data labels on a chart. False to hide. Read/write Boolean.


expression Required. An expression that returns one of the objects in the Applies To list.


The chart must first be active before you can access the data labels programmatically or a run-time error will occur.


This example enables the percentage value to be shown for the data labels of the first series on the first chart. This example assumes a chart exists on the active worksheet.

Sub UsePercentage()

    ActiveChart.SeriesCollection(1) _
        .DataLabels.ShowPercentage = True

End Sub

Applies to | DataLabel Object | DataLabels Collection Object