Bubble Chart in Excel

The insertion of a bubble chart requires you having your data laid out. Your data would look something like this:
dataBegin with marking all the whole data.mark dataOn 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