How to Change Bubble Size in Scatter Plot in Excel (with Simple Steps)

We will use this sample dataset to plot a Scatter Chart.

 

How-to-Change-Bubble-Size-in-Scatter-Plot-Excel


Step 1 – Insert Scatter Plot

  • Select cells in the B4:C10
  • Go to the Insert
  • Select Insert Scatter (X, Y) or Bubble ChartScatter Chart.

How to Change Bubble Size in Scatter Plot Excel Inserting Plot

  • It creates a Scatter Plot as shown.

How to Change Bubble Size in Scatter Plot Excel Inserting Plot


Step 2 – Use Marker Options

  • Double-click on any marker.

How to Change Bubble Size in Scatter Plot Excel Using Marker Option

  • The Format Data Series task pane opens.
  • Click on the Fill & Line icon.
  • Select the Marker section.
  • Expand the Marker Options menu.
  • Choose Built-in from the options and set the Size to 15.

How to Change Bubble Size in Scatter Plot Excel

  • Return to the chart. The size of the markers is changed.

How to Change Bubble Size in Scatter Plot Excel Using Marker Option


Step 3 – Add Axis Titles

  • Go to the Chart Design
  • Select Add Chart Element from the ribbon.
  • From the drop-down list, select Axis TitlesPrimary Horizontal.
  • Add the Primary Vertical title.

How to Change Bubble Size in Scatter Plot Excel Adding Axis Titles

  • Edit and give suitable Axis Titles relevant to the dataset.

How to Change Bubble Size in Scatter Plot Excel Adding Axis Titles


Step 4 – Add Chart Title

  • Add Chart Title to the chart.
  • Go to the Chart Design
  • Select Add Chart Element from the ribbon.
  • From the drop-down list, select Chart TitleAbove Chart.

How to Change Bubble Size in Scatter Plot Excel Adding Chart Titles

  • Edit and give a suitable Chart Title relevant to the dataset.

How to Change Bubble Size in Scatter Plot Excel Adding Chart Titles


Method 1 – Scaling Bubble Size to Change Bubble Size in Scatter Plot in Excel

Steps:

  • Select cells in the B6:D10
  • Go to the Insert
  • Select Insert Scatter (X, Y) or Bubble ChartBubble.

How to Change Bubble Size in Scatter Plot Excel Scaling Bubble Size

  • This opens a Bubble Chart beside the dataset.

How to Change Bubble Size in Scatter Plot Excel Scaling Bubble Size

In the chart above, there is a negative value in the vertical axis that we don’t need. To remove it:

  • Double-click on the vertical axis.
  • The Format Axis task pane is visible now.
  • Click on the Axis Options.
  • Set 0 as the Minimum value in the Bound.

How to Change Bubble Size in Scatter Plot Excel

  • The Bubble Chart now looks as shown.

How to Change Bubble Size in Scatter Plot Excel Scaling Bubble Size

The negative part is no longer visible.

  • Double-click on any data point.

How to Change Bubble Size in Scatter Plot Excel Scaling Bubble Size

  • This opens the Format Data Series task pane.
  • Click on the Series Options
  • Expand the Series Options
  • Insert 200 in the box of Scale bubble size to.

How to Change Bubble Size in Scatter Plot Excel

  • The bubble of this chart is bigger.

How to Change Bubble Size in Scatter Plot Excel Scaling Bubble Size


Method 2 – Adding a New Series to Change Bubble Size in Scatter Plot in Excel

The example dataset below shows Region-wise Sales Report of two states: Texas and Florida. This report includes the Sales Quantity and Profit percentages for the corresponding Weeks.

How to Change Bubble Size in Scatter Plot Excel Adding New Series

The Sales Quantity of each state the same. But the Profit in Florida is three times of Texas.

We will plot two different Bubble Charts from this dataset.

Steps:

  • Insert the chart as shown in Method 1.

How to Change Bubble Size in Scatter Plot Excel Adding New Series

The above chart is not giving the right presentation of data.

  • Add a new row of data in each table like the image below.

Adding New Series

In row 10, we added the same values in each table.

  • Right-click on the Bubble Chart.
  • Select the Select Data.

Adding New Series

  • It opens the Select Data Source dialog box.
  • Click on the Add button in the Legend Entries (Series).

Adding New Series

  • The Edit Series dialog box opens.
  • Select the relevant cells for the text boxes as shown in the image below.
  • Click OK.

Adding New Series

  • A new series named Series 2 is added to the 1st  Bubble Chart.
  • Click OK.

Adding New Series

  • Add a new series for the chart of Florida.
  • The charts should look as shown in the below.

Adding New Series

  • Blue bubbles are for Series 1. They are of the main dataset. The proportion of the size of the bubble in these 2 charts is correct.
  • Click on the orange bubble of chart 1.

Adding New Series

  • The Format Data Series task pane now.
  • Click on the Fill & Line.
  • Choose No fill from the Fill.

Adding New Series

  • Follow the same steps for the orange bubble of the 2nd chart.
  • The charts look as shown in the image below.

Adding New Series

Tbe bubbles are perfectly proportional according to the two different graphs.


Download Practice Workbook


Related Article


<< Go Back To Edit Scatter Chart in ExcelScatter Chart in Excel | Excel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shahriar Abrar Rafid
Shahriar Abrar Rafid

Shahriar Abrar Rafid, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked with the ExcelDemy project for more than 1 year. He has written over 100+ articles for ExcelDemy. He is a professional visual content developer adept at crafting scripts, meticulously editing Excel files, and delivering insightful video tutorials for YouTube channels. His work and learning interests vary from Microsoft Office Suites and Excel to Data Analysis, VBA, and Video recording and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo