How To Make A Bubble Chart In Excel. In the Select Data Source dialog add series by. The bubble chart is a variant of the scatter chart with data points marked by circles.
Then in the Edit Series dialog select the relative cells into the text boxes. Create an elaborate bubble chart Copy the example worksheet data into a blank worksheet or open the worksheet that contains the data that you want to. Create a blank workbook or worksheet.
By default the Size value is proportional to the area of the circle.
Click Insert Insert Scatter X Y or Bubble Chart Bubble to create a bubble chart. Select the new series bubble and right click to select Format Data Series. Right click at the blank bubble chart and click Select Data from the context menu. It would require multiple two-variable scatter plots in order to gain the same number of insights.