Export (0) Print
Expand All

DataLabels.ShowBubbleSize Property

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

Syntax

expression.ShowBubbleSize

expression   An expression that returns a DataLabels object.

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.

Visual Basic for Applications
Sub UseBubbleSize()

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

End Sub



Community Additions

ADD
Show:
© 2014 Microsoft