Expand Minimize

SizeRepresents Property

Returns or sets what the bubble size represents on a bubble chart. Read/write XlSizeRepresents .

XlSizeRepresents can be one of these XlSizeRepresents constants.

xlSizeIsArea

xlSizeIsWidth

expression.SizeRepresents

expression Required. An expression that returns one of the objects in the Applies To list.

This example sets what the bubble size represents for the chart. (The example assumes that the chart is a bubble chart.)

myChart.ChartGroups(1).SizeRepresents = xlSizeIsWidth
Show:
© 2015 Microsoft