@BUBBLEMODE (Bubble Size in Bubble Charts)

This macro controls the appearance of bubbles in a bubble chart.

When bubble mode is activated (bActivate=1), bubble sizes are calculated using relative area. If the largest bubble represents a value of 100 and the smallest represents a value of 1 (for example), the smallest bubble will be 1/100th the area of the largest bubble. A bubble that represents a negative value will be drawn using the absolute value. In a data set such as 1, 50, -100, the -100 value is drawn as the largest bubble.

When bubble mode is disabled (bActivate=0), bubble sizes are calculated using a linear interpolation between the maximum and minimum. Negative values are drawn as smaller bubbles. In a data set such as 1, 50, -100, the -100 value is drawn as the smallest bubble.

SYNTAX:

@BUBBLEMODE bActivate

PARAMETERS:

bActivate ; 0=use normal bubble size calculations, 1=activate Excel-Style bubbles

EXAMPLE:

@BUBBLEMODE 0

@BUBBLEMODE 1

PERSISTENT:

NO

Next Macro Previous Macro Return to Alpha List

Next Macro in this Group Return to Group List