Edit

Share via

ChartGroup.SizeRepresents property (Excel)

  • Article

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.

Syntax

expression.SizeRepresents

expression A variable that represents a ChartGroup object.

Example

This example sets what the bubble size represents for chart group one.

Charts(1).ChartGroups(1).SizeRepresents = xlSizeIsWidth

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.