# Excel Bubble Chart

### Bubble Chart in Excel

In Excel Bubble Chart is the variation of Scatter chart and its data is plotted as bubble. If your data has three series of values then you can represent it with the help of bubble chart, So that one data series takes up x axis, other data series takes up y axis and the third data series is plotted as a size of bubble .

Data used for creation of Bubble chart in Excel is shown below

TemperatureNumber of ice creams soldRevenue
22105945
231211089
241341206
251451305
261671503
271891701
282021818
292342106
302552295
312672403
322792511
333012709
343052745
353302970

Lets discuss how to create Bubble Chart in Excel Step by Step

#### Excel Bubble Chart Step 1:

Select the data and click insert -> Scatter (X, Y) or Bubble Chart -> Bubble chart  as shown below

#### Excel Bubble Chart Step 2 :

Right click on the bubble and chose select data option

#### Excel Bubble Chart Step 3:

On Select data option click Edit then,

• Type the series name as Ice Cream Sales vs Temp.
• Assign X values from A2:A15(Temperature)
• Assign Y Values from B2:B15(Number of Ice creams sold)
• Assign the Bubble Size as C2:C15(Revenue)

Then Click ok

Now the chart will be looking like

#### Excel Bubble Chart Step 4:

Right Click on the Horizontal Axis, chose Format Axis , under Axis Options Increase the Minimum as shown below so that the chart becomes clearly Visible. Do the same for the vertical Axis as well

So the final Excel Bubble chart will be like

There you go !! you successfully created Bubble chart in Excel