The insertion of a bubble chart requires you having your data laid out.
What is bubble chart?
The simpliest examplation on what a bubble chart is. A bubble chart is a kind of a scatter chart. The only difference is that the values are presented as bubbles instead of dots. And that's it.
As an advantage over a scatter point please notice about additional dimension of bubble charts. Thanks to bubbles you are able to show additional dimension with the size of a bubble. That is not available for scatter charts. This is a main advantage of bubble charts.
The size of bubbles is the biggest disadvantage of a bubble chart as well. It is often that the size of a bubble might be confusing for the person who sees such type of a chart. Especially when seen for the first time.
THe second problem is that bubble may overlap which additionally worsens a visibility.
Because of that bubble chart should be used only when:
- there are three sets of data
- bubbles do not overlap
How to insert a bubble chart?
Your data would look something like this:
Begin with marking all the whole data.
On top, you should click on insert (1), and then click on the recommended chart (2).
Start with clicking on All Charts (1), then choose scatter (2), choose bubbles (3), and finally click ok (4).
Note: The size of bubbles are determined by the data. The bigger the values, the bigger the bubbles.
Note: You can customize the design as you wish, including the title.
Further reading: BCG Matrix