@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 - white filled with a black edge. 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 Crystal Reports bubble size calculations, 1=activate Excel-Style bubbles

EXAMPLE:

@BUBBLEMODE 0

@BUBBLEMODE 1

PERSISTENT:

NO

REQUIREMENTS:

Crystal Reports 10 or higher

Next Macro Previous Macro Return to Alpha List

Next Macro in this Group Return to Group List

Next New Macro Previous New Macro Return to New Macros Page