How to Create Bubble Chart in Excel


This post will guide you how to create bubble chart in Excel. How do I present your data in a bubble chart in Excel.

A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles.

Create Bubble Chart

Assuming that you have a list of data in range A1:C4, and you want to create a bubble chart based on those data in your worksheet. And you can do the following steps:

#1 select the data that   you want to plot in the bubble chart.

create bubble chart1

#2 go to INSERT tab, click Insert Scatter or Bubble Chart command under Charts group, and click 3-D Bubble from the Bubble section.

create bubble chart2

#3 one bubble chart will be created in your worksheet.

create bubble chart3

#4 right click on the bubble chart, and click Select Data from the drop down list, and the Select Data Source dialog will open.

create bubble chart4

#5 click Edit button under Legend Entries section, and the Edit Series dialog will open. You can set series name, Series X values, Series Y values, and Series bubble size as you need.

create bubble chart5 create bubble chart6

Video: Create Bubble Chart


Leave a Reply