This post will guide you how to create bubble chart in Excel. How do I present your data in a bubble chart in Excel.
A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles.
Assuming that you have a list of data in range A1:C4, and you want to create a bubble chart based on those data in your worksheet. And you can do the following steps:
#1 select the data that you want to plot in the bubble chart.
#2 go to INSERT tab, click Insert Scatter or Bubble Chart command under Charts group, and click 3-D Bubble from the Bubble section.
#3 one bubble chart will be created in your worksheet.
#4 right click on the bubble chart, and click Select Data from the drop down list, and the Select Data Source dialog will open.
#5 click Edit button under Legend Entries section, and the Edit Series dialog will open. You can set series name, Series X values, Series Y values, and Series bubble size as you need.