Home Charts Bubble Chart

Bubble Chart

Bubble Chart in Excel

The insertion of a bubble chart requires you having your data laid out. Your data would look something like this:

Begin with marking all the whole data. mark data

On top, you should click on insert (1), and then click on the recommended chart (2).

insert recommended chart

Start with clicking on All Charts (1), then choose scatter (2), choose bubbles (3), and finally click ok (4).

3d bubble chart

Note: The size of bubbles are determined by the data. The bigger the values, the bigger the bubbles.

ready bubble chart

Note: You can customize the design as you wish, including the title.

You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References
BCG Matrix