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.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-35.png)
Click any blank cell and click insert, then Scatter or Bubble chart, choose one type you like.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-36.png)
Now we got a blank chart in the worksheet, click the blank chart and go to the Select Data under the Design tab.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-37.png)
Click Add button in the popped-out Select Date Source dialog box.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-38.png)
Add the corresponding dates in the Edit Series window box like the screenshot.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-39.png)
Hit Ok and close the dialog, we got a bubble chart now.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-40.png)
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.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-41-803x720.png)
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-42.png)
If you want to beautify these bubbles. You can also right-click one bubbly to open the Format Data Series pane.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-43.png)
Check the box to make every bubble in a different color.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-44.png)
If you want to name these cute bubbles, you can set the value from product cells.
![How to Create a Bubble Chart in Excel? How to Create a Bubble Chart in Excel?](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-45.png)
![bubble chart](https://www.myofficetricks.com/wp-content/uploads/2022/09/image-46.png)
You got a perfect bubble chart now. Hope this can be helpful.
Leave a Reply