How to draw a bubble diagram?

The drawing method of bubbles is as follows:

To make a bubble chart, you need to prepare a computer with Internet access (both laptop and desktop), and then you need to install excel software to make a bubble chart.

1. Insert a bubble chart, select the data source B3:G6 cell area, and then click the Insert tab-3D bubble chart in scatter chart.

2. Change the data series, select the chart, click the right mouse button to set the selected data, select the sales volume to be deleted (X axis), and then click Edit to change the data series.

At the series name, select the gross profit margin in the original table, area B6;

At the X-axis series value, select the second row region C4: G4 in the original table;

At the Y-axis series value, select the third row area C5: G5 in the original table;

Series bubble size, select the fourth row area C6:G6 in the original table.

3. Change and set the data label format, select the chart, click+,select the data label-center, select the label number, click the right mouse button to select and set the data label format-check the value in the cell, select the data area as C3:G3 in the original table, and then remove the check symbol of Y value, so as to adjust the format of the item ABCDE to the middle.

4. Beautify the chart, adjust the bubbles to different colors, or choose different colors according to your own preferences, and delete the chart title and legend.