This documentation is archived and is not being maintained.

ShowValue Property

Allows the user to show the value for the data labels on a chart. 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.

This example enables the value to be shown for the data labels of the first series on the first chart.

Sub UseValue() 
 ActiveChart.SeriesCollection(1) _ 
 .DataLabels.ShowValue = True 
End Sub