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 ***
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.
STEP 1: Select the table on where we want to create the chart on.
STEP 2: Go to Insert > Other Charts > Bubble.
STEP 3: Click on Series1 and Click Delete to remove it.
STEP 4: Press Ctrl+1 to open the Format Axis Panel.
STEP 5: Under Axis Options > Minimum > Fixed set the value to 0.
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.
Type Age of House.
Go to Primary Vertical Axis Title > Rotated Title.
Type KMs to City.