Edit

DataLabels.ShowValue property (Excel)

  • Article

Returns or sets a Boolean corresponding to a specified chart's data label values display behavior. True displays the values. False to hide. Read/write.

Syntax

expression.ShowValue

expression A variable that represents a DataLabels object.

Remarks

The specified 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 value to be shown for the data labels of the first series, on the first chart. This example assumes that a chart exists on the active worksheet.

Sub UseValue() 
 
 ActiveSheet.ChartObjects(1).Activate 
 ActiveChart.SeriesCollection(1) _ 
 .DataLabels.ShowValue = 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.