Bubble Chart 3 Variables

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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...
Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart.For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables.Well you c...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...