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
Temperature | Number of ice creams sold | Revenue |
---|---|---|
22 | 105 | 945 |
23 | 121 | 1089 |
24 | 134 | 1206 |
25 | 145 | 1305 |
26 | 167 | 1503 |
27 | 189 | 1701 |
28 | 202 | 1818 |
29 | 234 | 2106 |
30 | 255 | 2295 |
31 | 267 | 2403 |
32 | 279 | 2511 |
33 | 301 | 2709 |
34 | 305 | 2745 |
35 | 330 | 2970 |
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