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

Adding Data Labels To An Excel Chart Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points.Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.In ou...
Create a Treemap Chart With Excel 2016  Treemap Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.The tree branches are represented by rectangles, wherein each rectangle's siz...
Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.This overlay of graphs may seem like a difficult exercise but it is a very easy process.First you need to edit your "Plan" graph by clicking on its series and pres...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story.You can adjust the WIDTH of the line to make it as thin or thick as you like.You can make your line chart have a COMPOUND or DASH effect.You can also add...