Scaling the Size of the Bubbles in a BCG or Bubble Chart

Consulting Tools

BCG and bubble charts are another tool consultants can easily create in Excel. But, it helps if you know how to scale the size of the bubbles.

If you have only a few bubbles in your bubble chart and do not specify a Z value, the initial bubble size is monstrous. The bubble size can represent a Z factor, such as Revenue, ROI, Risk, etc. But, you will often need to scale the bubbles so they are more appropriately sized and aren’t too dense.

To scale the bubble size, right-click on a bubble so the entire series of bubbles are selected. Choose Format Data Series. Enter a scaling factor for bubbles.