How to make EXCEL bubble chart

Bubble chart can help us clearly observe the changing trend of data, so how to make bubble chart in Excel? Let me share it with you.

Tools/materials EXCEL

0 1 First, we open the Excel software to prepare the data of bubble chart, as shown below.

Next, select X, Y coordinate axis data and bubble column data, as shown in the figure below.

Then, we click the chart drop-down menu at the top and select the bubble chart type, as shown in the figure below.

Finally, we can see that Excel has automatically made a bubble chart for us, as shown in the following figure.