Share via


DataLabels.ShowPercentage Property

Excel Developer Reference

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

Syntax

expression.ShowPercentage

expression   A variable that represents a DataLabels object.

Remarks

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

Example

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.

Visual Basic for Applications
  Sub UsePercentage()
ActiveSheet.ChartObjects(1).Activate
ActiveChart.SeriesCollection(1) _
    .DataLabels.<strong>ShowPercentage</strong> = True

End Sub

See Also