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.RPT
@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 Previous Macro in this Group Return to Group List