SizeRepresents Property
Returns or sets what the bubble size represents on a bubble chart. Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth. Read/write Long.
Example
This example sets what the bubble size represents for chart group one.
Charts(1).ChartGroups(1).SizeRepresents = xlSizeIsWidth