Set up an Excel bubble chart with three numeric columns for each data point: an X value, a Y value, and a bubble-size value. Put each point on its own row, select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble; use a separate text column for names you want to show as labels.
The basic data layout
Excel needs three values to plot a bubble: its horizontal position, its vertical position, and its size. Arrange those values in adjacent columns with a descriptive header in the first row. Each row below the headers represents one observation, such as a product, region, project, or customer segment.
| Segment | Growth (X) | Margin (Y) | Sales (size) |
|---|---|---|---|
| North | 8 | 12 | 120 |
| South | 5 | 9 | 80 |
| East | 11 | 7 | 150 |
| West | 3 | 14 | 60 |
In this example, Growth determines left-to-right position, Margin determines up-and-down position, and Sales determines relative bubble size. Segment is a label field, not one of the three numeric inputs. Keep labels in a separate column so they can be applied to the bubbles after the chart is created.
Use consistent units within each numeric column. For example, enter growth and margin as percentage points (8 and 12) or as percentage values (8% and 12%), but do not mix the two conventions in the same column. Excel can plot dates and numbers, but text such as words, currency symbols typed into cells, or values like 8 percent may prevent the chart from treating a column as numeric data.
What each bubble-chart field means
A bubble chart is a scatter chart with a third variable encoded by bubble size. The X and Y columns locate each point on a two-dimensional plot, while the size column controls the relative size of its marker. This makes the chart useful when a table contains three related measures for each item and readers need to compare both position and magnitude.
- X value: the measure shown on the horizontal axis, such as growth rate, time, or cost.
- Y value: the measure shown on the vertical axis, such as margin, score, or output.
- Size value: a nonnegative measure represented by the bubble, such as sales volume, population, or project budget.
Bubble size values should generally be positive. A zero-sized point may not be visible, and negative values do not make sense as bubble areas. Also, the numbers are not literal diameters: entering a size of 200 does not make a bubble twice as wide as one with a size of 100. Treat the size encoding as a visual comparison, and retain the underlying values in labels or a companion table when exact reading matters.
Prepare and check the source data
Before inserting the chart, check that each record is complete and that the three plotted columns contain numeric values. Blank cells, text-formatted numbers, and inconsistent units can produce missing points or unexpected positions. If some records have no size value, decide whether to omit those records or fill the value from a reliable source rather than guessing.
Sort order does not determine where a bubble appears; the numeric X and Y values do. Still, sorting the table by a name or a meaningful measure can make the source easier to audit. Keep the headers directly above the data and avoid merged cells or blank rows inside the range. If you plan to add rows later, an Excel Table can make the source range easier to maintain, though you should check that the chart includes newly added records.
Review unusual values before charting. One very large size value can make smaller bubbles difficult to distinguish, and an extreme X or Y value can stretch an axis until most points cluster together. These may be valid observations, not errors, so verify them rather than deleting them simply to improve the appearance.
Create the bubble chart in Excel for Microsoft 365
- Arrange the X, Y, and size columns next to each other, with headers above them. For the example table, that is Growth, Margin, and Sales.
- Select the three numeric columns, including their headers. If the label column is beside them, leave it out of this initial selection.
- On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the ordinary Bubble option for a flat chart; the 3-D Bubble option changes the visual style and can make comparisons harder.
- Check that Excel assigned the first numeric column to X values, the second to Y values, and the third to bubble size. Add a chart title and axis titles from the chart elements controls if the measures are not obvious.
If Excel plots the wrong columns or treats rows as separate series, correct the mapping rather than rebuilding the worksheet. Select the chart, open Chart Design > Select Data, choose the series, and click Edit. Set the series X values to the Growth cells, Y values to the Margin cells, and bubble size to the Sales cells. Exclude the header row from those value ranges. The series must use matching row counts so that each X, Y, and size value belongs to the same observation.
Excel for Mac has the same underlying three-column data requirement, although chart controls and ribbon presentation can vary by release. In Excel for the web, chart creation and formatting options may be more limited than in the Windows desktop app; if a needed bubble-chart setting is missing, open the workbook in desktop Excel.
Add names and useful labels
Bubble charts do not automatically use a neighboring text column as point labels in every setup. To show names such as North or South, click a bubble to select the data series, then use Chart Design > Add Chart Element > Data Labels to add labels. Right-click a label and choose Format Data Labels. In the formatting pane, enable Value From Cells, select the cells containing the names, and confirm. Turn off numeric label options you do not want, such as X Value or Y Value, so the name is not crowded by extra numbers.
Labels are especially helpful when bubbles are few and well separated. With many points, labels can overlap and make the chart less readable. Consider labeling only notable points, reducing label text, or using a data table alongside the chart. A legend identifies series, not necessarily individual bubbles, so it cannot replace point labels when all observations belong to one series.
Format axes and bubble sizes
Axis titles should state both the measure and, when useful, its unit. If the X axis is growth in percent and the Y axis is margin in percent, say so explicitly; unexplained values like 8 and 12 can be misread. To set the displayed range or number format, right-click an axis and choose Format Axis. A fixed minimum and maximum can make comparisons between related charts easier, but an unsuitable range can hide points or exaggerate small differences.
To change the relative size appearance, select a bubble, open Format Data Series, and look for the bubble-size scale setting. The available controls can vary slightly with chart version and selection. Adjusting the scale changes how large the bubbles appear, not the underlying source values. If a large bubble hides a smaller one at the same coordinates, changing transparency or border formatting can help reveal overlap, but it does not remove the overlap itself.
Keep colors purposeful. A single series may need only one fill color; multiple series can use distinct colors if color is encoding a meaningful category. Avoid using color as the only way to distinguish groups when the chart may be printed in grayscale or viewed by people with color-vision differences. A clear legend or direct labels can provide another cue.
Common setup problems and fixes
- The bubbles are in the wrong places: confirm the X and Y ranges in Select Data. The columns may have been reversed or the text column may have been included accidentally.
- Only one bubble appears: check whether Excel read the selected rows as one point or whether the series ranges include only one numeric row. Edit the series so all corresponding records are included.
- Some rows are missing: inspect for blank cells, text-formatted numbers, error values, or mismatched range lengths. Make sure the X, Y, and size ranges start and end on the same rows.
- One bubble overwhelms the rest: verify the underlying size value first. If it is valid, adjust the bubble-size scale or reconsider whether a bubble chart is the best way to show the data.
- Labels show numbers instead of names: use Value From Cells in Format Data Labels and select the label cells; do not expect Excel to infer the names automatically.
Another frequent misconception is that a bubble chart is a three-dimensional chart because it uses three measures. It is still a two-dimensional plot: only X and Y determine position, while the third measure is represented by marker size. A 3-D Bubble style does not add a fourth data field, and perspective effects can make size comparisons less precise.
When a bubble chart is the right choice
Use a bubble chart when each record has three meaningful numeric measures and the audience can interpret their relationship. It can help compare product growth, profit margin, and sales volume, or compare countries by two rates and population. It is less suitable when the size measure is the main thing readers must compare exactly, when there are many overlapping records, or when the values do not have a sensible relationship.
A regular scatter chart is often clearer if only X and Y matter. A column or bar chart is usually easier for ranking a set of categories by one measure. If bubble sizes must communicate exact quantities, a table or labeled bar chart may communicate them more reliably. A bubble chart adds visual density, but that benefit is worthwhile only when the third variable adds useful context.
Frequently Asked Questions
What data do I need for an Excel bubble chart?
Use one numeric column for X position, one numeric column for Y position, and one numeric column for bubble size. Keep one observation per row and use a separate text column for names or categories.
Can I use text labels as the bubble sizes?
No. Bubble size must come from numeric values. Keep category names in a separate column and apply them through Format Data Labels > Value From Cells.
Why does my bubble chart show the wrong points?
The series may have the wrong X, Y, or size ranges, or the selected range may have been interpreted in an unintended orientation. Use Chart Design > Select Data > Edit to assign each numeric range explicitly and check that all ranges cover the same rows.
Can bubble size represent a percentage?
Yes, if the percentage is a meaningful nonnegative measure and is entered consistently. Remember that bubble size is a visual encoding, not a direct printed diameter; label the chart and consider showing the exact percentage in a data label or table.
How do I add names to bubbles in Excel?
Add data labels, open Format Data Labels, select Value From Cells, and choose the cells containing the names. Turn off other label values if you want the chart to show names only.
Can Excel make a bubble chart from just two columns?
A bubble chart needs three numeric inputs per point: X, Y, and size. With only two measures, use a scatter chart instead, or find a meaningful third measure before choosing a bubble chart.
Related
- Excel Drop-Down Lists: How to Create and Manage Them
- How to Insert a Checkbox in Excel: Steps and Tips
- Change Text to Numbers in Excel: Easy, Reliable Methods
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Chore Chart Template: Build a Shared ScheduleA Google Sheets chore chart template is a shared spreadsheet for listing household tasks, assigning them, and marking…
- Add a Goal Line to an Excel Chart: Steps That WorkTo add a goal line to an Excel chart, add a second data series containing the goal value…
- Excel PivotTable Charts: How to Create and Use ThemTo create an Excel PivotChart in Microsoft 365 for Windows, click a cell in a PivotTable, choose PivotTable…
- Bar Chart Maker in Excel: Create and Format ChartsExcel has a built-in bar chart maker: select your category labels and values, then choose Insert > Insert…
- Excel Pivot Table: Move a Row Field to Column LabelsTo move a row field to columns in an Excel PivotTable, click inside the PivotTable, open PivotTable Analyze…
- Insert a Live Excel Chart Into PowerPoint and Update ItTo insert a live Excel chart into PowerPoint, copy the chart in Excel, then in PowerPoint for Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.