Yes. In Excel for Microsoft 365 on Windows, arrange your data in columns for X values, Y values, and bubble size, select the range, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Excel plots each row as a bubble, so you can compare three numeric measures in one chart.
What a bubble chart shows
A bubble chart is a type of XY scatter chart. Each data point has a horizontal position, a vertical position, and a bubble size. The X and Y values determine where the bubble appears; a third numeric value determines its size. This lets a reader see relationships among three measures at once, rather than comparing only two as in a basic scatter chart.
For example, a retailer could plot product profit on the X-axis, customer satisfaction on the Y-axis, and units sold as bubble size. A product in the upper-right area would have relatively high profit and satisfaction, while a large bubble would indicate greater sales volume. The chart can reveal clusters and unusual cases, but it does not explain why those patterns occur; the underlying figures and business context still matter.
Bubble charts are most useful when the X and Y measures are numeric and the size measure adds meaningful context. They are less effective when there are many overlapping points, when the size values are hard to compare, or when a category-by-category ranking is the main goal.
Prepare the data before inserting the chart
Put one observation on each row and give each column a clear heading. A simple layout might have Product in column A, Profit in column B, Satisfaction in column C, and Units sold in column D. Profit and satisfaction will supply the coordinates, while units sold will control bubble size. The product names are useful identifiers, but they are not one of the three numeric measures.
- Use numeric values for the X, Y, and size columns. Text such as “High” or “Medium” cannot serve as a numeric coordinate or bubble size.
- Keep the three numeric measures in separate columns, with the same row corresponding to the same observation in each column.
- Use positive values for bubble size. Zero or negative values do not produce a meaningful visible bubble, so check the source data before charting.
- Include column headings, and check for blank rows or cells that could make the chart incomplete or confusing.
You can keep the name column alongside the numeric columns, but Excel may not automatically use names as point labels. If you want named bubbles, add the labels after creating the chart. For a very large dataset, consider whether a subset or a filter would make the display easier to read.
Create a bubble chart in Excel for Windows
- Click a cell in the prepared data range, or select the relevant columns, including their headings.
- Go to the Insert tab. In the Charts group, choose Insert Scatter (X, Y) or Bubble Chart.
- Choose Bubble for a standard two-dimensional bubble chart. Excel creates a chart from the selected data.
- Check that the horizontal axis, vertical axis, and bubble sizes correspond to the intended columns. If Excel assigned a range incorrectly, select the chart and go to Chart Design > Select Data.
In the Select Data Source dialog, use the series controls to add or edit the data series. The Edit Series dialog has fields for the series name, Series X values, Series Y values, and Series bubble size. Set each field to the corresponding numeric cells, excluding the heading if Excel does not handle it as a series name. For example, if the first data row is row 2 and the last is row 12, the X, Y, and size ranges should each cover rows 2 through 12. Matching range lengths are important because each set of values describes the same points.
On a Mac, the ribbon wording and chart gallery layout can differ by Excel release; look under Insert > Chart for the Bubble chart type, then use the chart design or data-selection controls to correct the series. Excel for the web has chart creation and formatting features, but some advanced controls may be limited or arranged differently. If you cannot find a particular label or series option in the web app, open the workbook in desktop Excel.
Format the axes and bubble sizes
After insertion, select the chart to reveal chart tabs and tools. Add a descriptive title, and use axis titles when the meaning or units of the measures are not obvious. A chart titled “Profit, satisfaction, and sales by product” is more informative than the default title. Axis titles such as “Profit ($ per unit)” and “Customer satisfaction (score)” explain what the positions mean and help prevent readers from confusing measures.
Use the plus-shaped Chart Elements button beside a selected chart, where available, to add elements such as axis titles, or use Chart Design > Add Chart Element. The exact choices displayed can depend on the selected chart and Excel version. To adjust the display of an axis, right-click the axis and choose Format Axis. Sensible minimum and maximum bounds can make a useful pattern easier to see, but avoid narrowing an axis in a way that exaggerates small differences without making the scale clear.
Bubble-size perception is not as precise as reading a position from an axis. A bubble with a larger size value will be drawn larger, but readers may find it difficult to judge exact ratios by eye. Keep the size measure meaningful, avoid using an extremely wide range without checking the result, and consider a legend or a few labeled reference points if readers need to interpret size. Excel’s formatting pane offers series and fill controls; restrained colors and some transparency can help when bubbles overlap.
Add point names and clarify the chart
Point labels are especially useful when the reader needs to identify individual products, regions, or projects. Select a bubble, add data labels through the chart element controls, and open Format Data Labels. In desktop Excel for Microsoft 365 on Windows, the label options can include Value From Cells. Choose the cells containing the names, then clear the X value, Y value, or bubble size label options if you only want names displayed. The exact pane layout can vary, so confirm that the labels show the intended information.
Labels can quickly crowd a chart. Label only key points, use short names, or label outliers rather than every observation. You can also include a small data table or a separate lookup table beside the chart if a full list of values is necessary. A legend generally identifies series, not every point within a single series, so it is not a substitute for point labels when each bubble represents a different item.
Give the chart a short note or subtitle when the size measure needs explanation. For instance, state whether bubble size represents annual units sold or a percentage. If the chart is copied into a presentation or report, include units and the period covered so the meaning survives outside the worksheet.
Worked example: products by profit, rating, and sales
Suppose a small store tracks three products. The data might have columns named Product, Profit per unit, Satisfaction score, and Units sold, with one product per row. In the chart, Profit per unit becomes the horizontal value, Satisfaction score becomes the vertical value, and Units sold determines bubble size. A product with higher profit and a higher rating appears farther to the right and higher up; a product with more units sold appears as a larger bubble.
This example also shows why the bubble size column must be chosen deliberately. If you use inventory on hand instead of units sold, the chart answers a different question. And if one item sold 10 units while another sold 10,000, the size range could make smaller bubbles difficult to distinguish. You could split the analysis into relevant groups or use a different chart if the extreme values obscure useful comparisons. Do not alter the underlying figures merely to make the visual look balanced; if you transform or filter data, explain that choice.
Before sharing the chart, compare a few bubbles with their rows in the source table. Verify that each point has the correct X and Y position and that the size reflects the intended measure. This simple check can catch a common setup error: selecting the right columns but assigning the wrong one to bubble size.
Common problems and how to fix them
- The chart looks like a scatter plot with equal-sized points: Check Chart Design > Select Data and confirm that a valid numeric range is assigned to Series bubble size.
- Points appear in unexpected places: Review the X and Y range fields, confirm that the values are numeric, and make sure the rows line up across all three ranges.
- Some bubbles are missing or tiny: Inspect the size data for blanks, zeros, negatives, or values much smaller than the largest observations. A large value can make the rest look insignificant.
- The chart is crowded: Reduce the number of observations shown, use transparent fills, label only selected points, or try a different visualization. Overlap can conceal data rather than communicate it.
- The axes show row numbers or unintended values: Edit the series ranges so the X and Y fields refer to the intended numeric columns, not the product-name column or an unrelated field.
Also check whether a blank cell has been interpreted as a zero or whether imported numbers are actually stored as text. In the worksheet, a value that looks numeric can sometimes be text after an import. Correct the source data and then confirm that the chart updates as expected. Avoid relying on bubble color to communicate a fourth measure unless you define the colors clearly and ensure the result remains understandable.
Bubble charts compared with other Excel charts
A bubble chart is not automatically the best chart just because the dataset has three columns. Use a scatter chart when two numeric measures are the main story and a size dimension would add clutter. Use a column or bar chart when the goal is to compare a small set of category totals, because lengths are generally easier to compare accurately than bubble areas. A line chart is usually more suitable when values are measured over time and the sequence matters.
Bubble charts work well for broad patterns, such as identifying groups with high values on two measures and distinguishing their relative scale. They are weaker for exact comparisons of bubble size, precise rankings, or dozens of overlapping categories. If readers need exact values, pair the chart with a clearly organized table or label selected data points. The chart communicates shape and relationships; the table supplies precision.
Frequently Asked Questions
Can Excel make a bubble chart with three variables?
Yes. The X values set horizontal position, the Y values set vertical position, and a third numeric range sets bubble size. Each row represents one point.
How do I add names to bubbles in Excel?
Add data labels, open Format Data Labels, and use Value From Cells to select the cells containing the names, where that option is available in your desktop Excel version. Turn off other label values if you want names alone.
Why are all the bubbles the same size?
The bubble-size range may be missing, invalid, or assigned incorrectly. Open Chart Design > Select Data, edit the series, and check the Series bubble size field. It should refer to numeric cells that match the X and Y ranges.
Can a bubble chart use text for its axes?
The X and Y positions in a bubble chart are numeric, so text categories cannot directly serve as the coordinate values. If you need category labels, consider a bar chart, or use numeric positions and clear point labels only when that arrangement is meaningful.
Can I make a bubble chart in Excel for the web?
Excel for the web supports many chart tasks, but available options can differ from desktop Excel. If a required feature, such as a particular data-label control, is not available in your workbook’s web interface, use Excel for Microsoft 365 on Windows or Mac for fuller chart editing.
Related
- How to Protect Cells in Excel and Control Editing Safely
- Excel Merge Zones: 11 Ways to Combine Cells and Data
- Excel Not Responding Due to Large Data: Causes and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Histogram Bin Number: How to Choose ItIn an Excel histogram, the bin number is the number of intervals used to group your numeric data.…
- Excel Overlapping Pivot Table Error: How to Fix ItExcel’s overlapping PivotTable error means a PivotTable is trying to occupy cells already used by another PivotTable on…
- Add Power Pivot to Excel: Enable It and Get StartedTo add Power Pivot in Excel for Microsoft 365 on Windows, select File > Options > Add-ins, choose…
- Excel Trendline Not Showing? Causes and Fixes in ChartsIf the Trendline option is missing in Excel, select a data series inside the chart, not the chart…
- Excel Pivot Table Values Not Summing? Fix the CauseIf Excel PivotTable values are not summing, first check that the source column contains real numbers rather than…
- Add Excel Charts to PowerPoint: Link or Embed?To add an Excel chart to PowerPoint, select the chart in Excel, copy it, then paste it onto…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.