This topic has not yet been rated - Rate this topic

DataLabels.ShowValue Property

Office 2007

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 a chart exists on the active worksheet.

Visual Basic for Applications
`Sub UseValue() ActiveSheet.ChartObjects(1).Activate ActiveChart.SeriesCollection(1) _ .DataLabels.ShowValue = True End Sub`

Community Additions

ADD