Excel.Series.BubbleSizes.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Series.BubbleSizes property (Excel)	vbaxl10.chm578113	vbaxl10.chm578113	Excel.Series.BubbleSizes	41e56271-ec4c-7f9e-9642-174c8435e7d6	05/11/2019	medium

Series.BubbleSizes property (Excel)

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.

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

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

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

[!includeSupport and feedback]