To create a bubble chart in Excel for Microsoft 365 on Windows, arrange each observation in a row with an X value, a Y value, and a positive bubble-size value. Select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble; Excel plots the first two measures as coordinates and the third as bubble size.
What a bubble chart shows
A bubble chart is a variation of an X-Y scatter chart. Each bubble represents one observation: its horizontal position shows one numeric measure, its vertical position shows another, and its size represents a third. This makes it useful when a table contains three related quantities for each item and you want to compare patterns at a glance.
For example, a product team might plot average customer rating on the X-axis, units sold on the Y-axis, and use each product’s revenue as its bubble size. A product in the upper-right has both a high rating and high sales; a large bubble indicates higher revenue relative to the other products. The chart can reveal clusters and outliers, but it does not explain why they occur.
Bubble charts work best when the observations are individual, comparable items and all three measures are numeric. They are less suitable for precise comparisons of many values: people estimate position more accurately than area, so a reader may have difficulty deciding whether one bubble is exactly twice the size of another.
Prepare the data table
Put the data in a simple rectangular table with one header row and one row per observation. Use separate columns for the label, X value, Y value, and bubble size. For example, a table might have Product, Rating, Units Sold, and Revenue columns. The label column is useful later, but the chart’s three numeric columns are the values that determine the bubbles.
- Use numeric values for X, Y, and size. Text such as a currency symbol typed into a cell can make a value behave like text; apply number formatting instead.
- Keep the units and meaning of each measure clear in the headers. A chart should not leave readers guessing whether an axis shows dollars, percentages, or counts.
- Use positive size values. A zero-sized value cannot produce a visible bubble, and negative sizes do not represent a meaningful bubble area.
- Check for blank cells, errors, and rows that should not be included. A stray total row can become an unintended data point.
If you are building a chart for different groups, decide whether the groups should be separate series before inserting it. Separate series can help distinguish groups by color, but the X, Y, and size ranges for each series must line up row by row. A consistent table structure makes corrections much easier.
Create the bubble chart in Excel
In Microsoft 365 for Windows, follow these steps. If the chart does not map the three columns as expected, use Select Data to set each series range explicitly.
- Arrange the three numeric measures in adjacent columns, with headers in the first row. You can include the label column as well, but do not mistake it for a numeric measure.
- Select the X, Y, and size columns, including their headers. If you also select text labels, Excel may use them as series names or category labels rather than as point labels.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the standard Bubble option for a flat chart. Excel also offers a 3-D Bubble style; the 3-D appearance is a visual effect, not an additional data dimension.
- Check the chart’s axes and bubble sizes. If the result is wrong, right-click the chart and choose Select Data. Select the series and choose Edit, then specify the Series X values, Series Y values, and Bubble size ranges. Exclude the header cells from these numeric ranges.
- Move or resize the chart and add a title that explains what is being compared. Save the workbook after confirming that each visible bubble corresponds to the intended row.
For example, if the X values are ratings, the Y values are units sold, and the size values are revenue, a bubble should sit at the rating-and-sales coordinates for its product. Its size should be driven by that product’s revenue. A misplaced point often means that one of the ranges starts or ends on a different row.
Add labels that identify the bubbles
Excel may initially show no point names, leaving readers to infer which bubble belongs to which item. To add labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a position. The exact available commands can vary slightly with the ribbon layout and chart selection.
For product or location names, use labels from cells when that option is available in the Format Data Labels pane. Select the data labels, open the pane, choose Value From Cells, and select the cells containing the names. Clear other label options, such as X Value or Y Value, if they would add unnecessary numbers. If Value From Cells is not offered in your Excel build, you can label important points manually or use a small number of data labels with their values.
Labels should help identify points without obscuring them. If many names collide, label only the most important observations and explain the rest with a nearby table or a legend. A legend identifies series, not necessarily individual bubbles within a single series, so it may not solve a point-identification problem.
Format axes, bubbles, and titles
Give each axis a descriptive title with units, such as Average rating (out of 5) and Units sold (thousands). Select the chart, then use Chart Design > Add Chart Element > Axis Titles to add titles. Axis bounds and number formats can be adjusted through the Format Axis pane. Avoid cutting off a meaningful portion of the scale just to make the bubbles look more dramatic.
Use a clear chart title and, if needed, a short subtitle that states the time period or population. Keep the background and gridlines restrained so that the data remain prominent. If the chart has several series, use distinct, readable colors and make the color meaning explicit. Color should not be the only way readers can distinguish groups; labels or other visual cues can help.
Bubble sizes can dominate a chart when the size values have a wide range. Select a bubble and open Format Data Series to review the size-scaling controls available in your Excel version. Adjusting the display scale can improve visibility, but it does not change the underlying values. Do not resize bubbles in a way that suggests a false relationship, and explain the size measure in a legend or note where readers can see it.
Read the chart without overclaiming
First read the axis titles and units, then compare the positions of the bubbles. Nearby bubbles have similar X and Y values; a bubble far from the rest may be an outlier worth checking against the source data. Next compare sizes as a broad indication of the third measure. Remember that bubble area, not just its width, is the visual cue, and precise size estimates are difficult.
A bubble chart can show association, not prove that one measure caused another. If larger-revenue products also tend to have higher sales, that pattern alone does not show that revenue caused sales; revenue may be calculated from sales and price, for example. Check how the measures are defined and whether observations are comparable before drawing conclusions.
When a chart includes observations from different time periods or populations, make those differences visible. A large bubble might reflect a longer measurement period rather than a genuinely higher rate. For fair comparisons, consider normalizing counts by an appropriate denominator when that is meaningful, and state the resulting measure clearly.
Common problems and how to fix them
- The chart shows the wrong locations: Open Select Data and edit the series so the X, Y, and bubble-size ranges cover the intended numeric columns and the same rows.
- Bubbles are missing: Check for blank, zero, negative, or text size values. Also confirm that points are not hidden behind much larger bubbles.
- One bubble overwhelms the chart: Verify that the size column has no accidental extra zero or wrong unit. If the data are valid, use the available bubble size scaling control cautiously or choose another chart type.
- Names appear as numbers: In Format Data Labels, choose labels from the cells containing names when supported, and turn off unwanted X, Y, or size value labels.
- There is an unexpected extra point: Check whether a totals row or a header was included in the selected range. Edit the series ranges to exclude it.
- The chart is hard to read: Reduce the number of observations, simplify labels, clarify the units, or split distinct groups into separate charts.
Excel for Mac has bubble charts and similar chart-formatting controls, but ribbon arrangement and pane names can differ from Windows. In Excel for the web, chart editing capabilities may also differ by feature and account; if a particular formatting control is unavailable, open the workbook in the desktop app. The underlying data layout and interpretation are the same.
When to use a different chart
A bubble chart is appropriate when all three numeric measures matter and the audience can interpret the added size dimension. Use a plain scatter chart if the third measure is not essential; removing bubbles can make the relationship between X and Y easier to see. Use a bar chart when the main task is ranking categories precisely, especially if there are many items.
If the third measure is a category rather than a number, encode it with color or make separate charts instead of assigning arbitrary bubble sizes. If there are hundreds of points, a bubble chart can become crowded and hide observations. Consider filtering to a useful subset, using small multiples, or presenting a table alongside a simpler chart. The best choice depends on the question readers need to answer, not on how many dimensions a chart can display.
Frequently Asked Questions
Can an Excel bubble chart show three variables?
Yes. The X position, Y position, and bubble size represent three numeric measures. A bubble chart does not automatically create a fourth meaningful measure; its 3-D style is only a visual treatment.
How do I show names instead of numbers on the bubbles?
Add data labels, open Format Data Labels, and choose Value From Cells if that option is available in your Excel version. Select the cells containing the names, then clear numeric label options that you do not want to display.
Why are some bubbles not visible?
A point may have a blank, zero, negative, or nonnumeric size value, or it may be hidden underneath a larger bubble. Check the size range and the source row, then adjust the chart’s bubble scale or reduce overlap if needed.
Can I use text categories for the bubble size?
No. Bubble size must be based on numeric values. For categories such as region or product type, use separate series, labels, or colors instead of assigning numbers that imply a size relationship.
Is a bubble chart better than a scatter chart?
Only when the third numeric measure adds useful information. A scatter chart is usually easier to read when the main goal is comparing two variables, while a bubble chart adds a third measure at the cost of making precise comparisons harder.
Related
- Access vs Excel: Pros, Cons, and Best Uses Compared
- Accidentally Didn’t Save an Excel File? Recover It
- Access Database vs Excel Spreadsheet: Which to Use?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Access Power Pivot in Excel 365: Enable and Use ItTo access Power Pivot in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose…
- Think-Cell Waterfall Chart: How It Works and When to Use ItA think-cell waterfall chart is a PowerPoint chart that shows how a sequence of positive and negative changes…
- Google Sheets Progress Meter: Make a Chart or BarIn Google Sheets, the quickest progress meter is a SPARKLINE bar inside a cell: if B2 contains a…
- Pivot Chart Not Showing All Data? How to Fix ItA PivotChart usually misses data because its PivotTable source has not been refreshed or expanded, or because a…
- Excel Line Charts: Ignore Blank Cells or Show Gaps?Yes. In Excel for Microsoft 365 on Windows, select the line chart, choose Chart Design > Select Data…
- Excel Pie Chart Legend on Slices: How to Add LabelsYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.