You can also choose to scale the circles from 0 to 300% by changing the BubbleScaleprop-
erty from
0to 300. The top-left chart in Figure 13.25 has a 100% scale. The top-right
chart uses a 50% scale. The bottom-right chart uses a 300% scale.
Finally, you can specify whether Excel should show negative-sized circles on a chart. In the
lower-right chart in Figure 13.25, the –2 in the upper quadrant is represented by a circle
with a white fill instead of a circle with a blue fill.
The following macro demonstrates some of the settings available for bubble charts:
Sub BubbleSettings()
Dim chtg As ChartGroup ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.