Share via

HasValue Property

  • Article

True if every data label for the specified series or chart currently displays its y-axis value. The default value is False. Read/write Boolean.

expression.HasValue

*expression   * Required. An expression that returns a ChDataLabels object.

Remarks

Data label components are always displayed in the following order: [SeriesName] [CategoryName] [Value] [BubbleSize] [Percentage].

Setting this property to True on a scatter chart or polar chart causes both x-axis values and y-axis values to be displayed.

Example

This example sets the data labels for the specified series to display their y-axis values.

ChartSpace1.Charts(0).SeriesCollection(0).DataLabelsCollection(0)HasValue = True

Applies to | ChDataLabels Object

See Also | HasBubbleSize Property | HasCategoryName Property | HasPercentage Property | HasSeriesName Property