Excel bubble chart size based on value

This tutorial provides a step-by-step example of how to create the following bubble chart with labels in Excel:

Step 1: Enter the Data

First, let’s enter the following data into Excel that shows various attributes for 10 different basketball players:

Step 2: Create the Bubble Chart

Next, highlight the cells in the range B2:D11.

Then click the Insert tab along the top ribbon and then click the Bubble Chart option within the Charts group:

The following bubble chart will automatically be created:

The x-axis displays the points, the y-axis displays the assists, and the size of each bubble represents the rebounds.

However, it’s tough to know which bubbles represent which players because there are no labels.

Step 3: Add Labels

To add labels to the bubble chart, click anywhere on the chart and then click the green plus “+” sign in the top right corner.

Then click the arrow next to Data Labels and then click More Options in the dropdown menu:

In the panel that appears on the right side of the screen, check the box nex

bubble chart in excel with multiple series

bubble chart in excel template