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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Pie Charts in Excel Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis. Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of c...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization: Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Benchmark Chart in Excel 2013 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts. ...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points. To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...