Series.BubbleSizes Property

Excel Developer Reference

Returns or sets a string that refers to the worksheet cells containing the x-value, y-value and 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 R1C1-style notation. Applies only to bubble charts. Read/write Variant.

Syntax

expression.BubbleSizes

expression   A variable that represents a Series object.

Example

This example displays the cell reference for the cells that contain the bubble chart x-value, y-value and size data.

Visual Basic for Applications
  MsgBox Worksheets(1).ChartObjects(1).Chart _
    .SeriesCollection(1).BubbleSizes

This example shows how to set this property using R1C1-style notation.

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

See Also