A Bubble Chart is an extension of the XY Scatter Chart.  It adds a 3rd variable to each point in the XY Scatter Chart.

For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of the house (the 3rd variable), then a Bubble Chart will get you there.

The value of the house (the 3rd variable) will determine the size of the bubble, the age of the house is on the X-axis and the proximity to the city is on the Y-axis, as shown below.

Want to know how to create a Bubble Chart with Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍





STEP 1: Select the table on where we want to create the chart on.  

Bubble Chart 3 Variables

STEP 2: Go to Insert > Other Charts > Bubble.

Bubble Chart 3 Variables


STEP 3: Click on Series1 and Click Delete to remove it.

Bubble Chart 3 Variables

STEP 4: Press Ctrl+1 to open the Format Axis Panel.

Bubble Chart 3 Variables


STEP 5: Under Axis Options > Minimum > Fixed set the value to 0.

Bubble Chart 3 Variables


STEP 6: Under Chart Tools > Layout >Axis Titles and follow the next steps to customize your chart.

Go to Primary Horizontal Axis Title > Title Below Axis.

Bubble Chart 3 Variables

Type Age of House.

Bubble Chart 3 Variables

Go to Primary Vertical Axis Title > Rotated Title.

Bubble Chart 3 Variables

Type KMs to City.

Bubble Chart 3 Variables

Bubble Chart 3 Variables

Helpful Resource:

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn