HasBubbleSize Property

Microsoft Office Web Components Visual Basic

True if every data label for the specified series or chart currently displays its bubble size. The default value is False. Note that this property is available only for bubble charts. Read/write Boolean.

expression.HasBubbleSize

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].

Example

This example causes the data labels for the specified series to display their bubble size. Note that Charts(0) must refer to a bubble chart.

Sub DisplayLabels()
    Dim dlBubbleLabels
    
    Set dlBubbleLabels = ChartSpace1.Charts(0).SeriesCollection(0).DataLabelsCollection.Add
    
    dlBubbleLabels.HasBubbleSize = True
End Sub