[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.

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.

Video

Notes

Real-world example