ChartGroup.SizeRepresents (Excel)

Returns or sets what the bubble size represents on a bubble chart. Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth. Possible return values are xlSizeIsArea - Area of the bubble, xlSizeIsWidth - Width of the bubble.

ActiveChart.ChartGroups(1).SizeRepresents = xlSizeIsArea