HasPercentage Property

True if every data label for the specified series or chart currently displays its percentage value. The default value is False. This property is available only for pie, doughnut, and stacked charts. Read/write Boolean.

expression   Required. An expression that returns a ChDataLabels object.

Remarks

Data label components are always displayed in the following order: [SeriesName] [CategoryName] [Value] [BubbleSize] [Percentage].

Example

This example adds data labels showing percentage value to a series. Note that Charts(0) must refer to a pie, doughnut, or stacked chart.

Sub AddPercentabeLabels()
    Dim dl
    
    Set dl = ChartSpace1.Charts(0).SeriesCollection(0).DataLabelsCollection.Add
    
    ' Display percentage labels.
    dl.HasPercentage = True
End Sub