[Excel] How to make a bubble chart

A bubble chart with a center dot in each bubble to make comparisons easier.

A bubble chart in Excel
A bubble chart in Excel.

Design notes

  • To display the center of the bubble, add the series twice, but use a small and fixed value for bubble size.
  • Check the aspect ratio.
  • Reduce opacity to avoid occlusion (larger bubbles hiding smaller ones).
  • Show bubble outline using a darker color.



Real-world example