ShowBubbleSize Property

True to show the bubble size for the data labels on a chart. False to hide. Read/write Boolean.

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

The chart must first be active before you can access the data labels programmatically or a run-time error will occur.

Example

This example shows the bubble size for the data labels of the first series on the first chart. This example assumes a chart exists on the active worksheet.

Sub UseBubbleSize()

    ActiveSheet.ChartObjects(1).Activate
    ActiveChart.SeriesCollection(1) _
        .DataLabels.ShowBubbleSize = True

End Sub