BubbleSizes Property

Microsoft Excel Visual Basic

Returns or sets a string that refers to the worksheet cells containing the size data for the bubble chart. When you return the cell reference, it will return a string describing the cells in A1-style notation. To set the size data for the bubble chart, you must use R1-style notation. Applies only to bubble charts. Read/write Variant.

Example

This example displays the cell reference for the cells that contain the bubble chart size data.

MsgBox Worksheets(1).ChartObjects(1).Chart _
    .SeriesCollection(1).BubbleSizes
		

This example shows how to set this property using R1-sytle notation.

Worksheets(1).ChartObjects(1).Chart _
    .SeriesCollection(1).BubbleSizes = "=Sheet1!r1c5:r5c5"