Series.BubbleSizes Property
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 |
|---|
|
This example shows how to set this property using R1C1-style notation.
| Visual Basic for Applications |
|---|
|