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.

DOWNLOAD EXCEL WORKBOOK

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin