ShowValue Property

  • Article

Allows the user to show the value for the data labels on a chart. Read/write Boolean.

expression.ShowValue

Remarks

The chart must first be active before you can access the data labels programmatically.

Example

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

  Sub UseValue()

ActiveSheet.ChartObjects(1).Activate
ActiveChart.SeriesCollection(1) _
    .DataLabels.<strong class="bterm">ShowValue</strong> = True



End Sub