Here’s a step-by-step guide to making circle charts (or “bubble” charts) in Microsoft Excel. You’ll learn how to use x, y, and z values to control the location and size of your circles.
In case you haven’t noticed, I’m a huge fan of Microsoft Excel. Sometimes evaluators are hesitant to use Excel. One misconception is that Excel is only good for 3-D exploding pie charts, boring bar charts, and random radar charts. But Excel can do more than you think! So here’s my challenge to you: can you make a circle chart in Excel?