X

How to Create a Bubble Chart in Excel?

There are many kinds of charts. Different charts present different effects. The bubble chart can visually show the relationship between the three variables. In this article, I will introduce how to create a bubble chart in Excel.

Take this table as an example.

Click any blank cell and click insert, then Scatter or Bubble chart, choose one type you like.

Now we got a blank chart in the worksheet, click the blank chart and go to the Select Data under the Design tab.

Click Add button in the popped-out Select Date Source dialog box.

Add the corresponding dates in the Edit Series window box like the screenshot.

Hit Ok and close the dialog, we got a bubble chart now.

As you can see, the bubbles are crowded. We can adjust the X axis. Just right-click on the chart and choose Format Plot Area.

If you want to beautify these bubbles. You can also right-click one bubbly to open the Format Data Series pane.

Check the box to make every bubble in a different color.

If you want to name these cute bubbles, you can set the value from product cells.

You got a perfect bubble chart now. Hope this can be helpful.

Categories: Excel Tips
Sandra: