Yes, you can make a bubble chart in Excel to plot two variables, but a bubble chart also needs a third numeric value to determine each bubble’s size. If you have only two variables and no meaningful size measure, an XY scatter chart is usually the clearer choice; you can still use a bubble chart by assigning every point the same size.
What a bubble chart represents
A bubble chart is a type of XY chart. Each point is positioned using two numeric values: one sets its horizontal location on the X axis, and the other sets its vertical location on the Y axis. A third value controls the bubble’s size. That makes it useful for comparing three measures at once, while still showing individual observations.
For example, a business might plot advertising spend on the X axis and sales on the Y axis, with bubble size showing the number of customers. A large bubble then means the observation has a larger third value, not necessarily greater sales or better performance. The chart does not automatically explain what a point represents, so labels, a legend, or a nearby note may be needed.
Unlike a column chart, a bubble chart does not use categories as its numeric horizontal positions. Its X and Y axes are both value axes, so the distances between points matter. That is why it works best when the data consists of paired numerical measurements rather than unrelated labels such as department names or product types.
Can a bubble chart show only two variables?
There are two different meanings of “two variables” here. If you mean two measured variables displayed as X and Y, yes: make the bubble size constant so it contributes no extra information. In Excel, use the same positive size value for every row. The points will then be the same size, and the chart will function visually much like a scatter chart.
If you mean that your data contains just two columns and you want bubble sizes to communicate something, there is not enough information to do that honestly. Excel needs a third number for bubble size. Do not let Excel use an arbitrary column, row number, or unrelated identifier as the size measure: that can make the chart look meaningful when its bubble sizes have no useful interpretation.
When all bubbles are identical, a regular scatter chart is generally preferable. It makes the two-variable relationship easier to read, avoids implying a third measure, and usually gives small or overlapping points better visibility. Choose a bubble chart when varying size adds a genuine, explainable third dimension.
Arrange the worksheet data
Put one observation on each row and keep the three numeric measures in separate columns. A practical layout is:
- Column A: a short label for the observation, such as a product or city.
- Column B: the X variable, such as advertising spend.
- Column C: the Y variable, such as sales.
- Column D: the size variable, such as customer count.
For a two-variable chart with equal bubbles, fill column D with the same positive number for every observation, such as 1. That number is only a visual size input; it does not represent a measured difference. Keep the header row separate from the numeric observations, and check that Excel recognizes the X, Y, and size columns as numbers rather than text. Values such as “$2,000” may be numeric if entered as a number with currency formatting, but pasted text can prevent correct plotting.
Bubble charts are most suitable for nonnegative size values. A zero-size point may be invisible, and negative values do not have an intuitive bubble-size interpretation. If a measurement can be zero or negative, consider whether it is appropriate to use as bubble size, or choose another visual encoding. Do not quietly change negative values to positive ones; that alters their meaning.
Create a bubble chart in Excel for Microsoft 365
In Excel for Microsoft 365 on Windows, you can insert a bubble chart from a selected data range. For a straightforward single-series chart, use the X, Y, and size columns together. If Excel maps the columns incorrectly, correct the series through Select Data.
- Arrange the data with X values, Y values, and bubble-size values in adjacent columns. Include clear headers and, if useful, keep labels in a separate column.
- Select the numeric columns, including their headers. For example, select B1:D11 when rows 2 through 11 contain ten observations.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the 3-D Bubble option only when you specifically want its perspective effect; the standard bubble chart is generally easier to compare.
- Inspect the chart to confirm the axes and bubble sizes correspond to the intended columns. If the mapping is wrong, right-click the chart and choose Select Data, select the series, and choose Edit. Set the series X values to the X column, the series Y values to the Y column, and the bubble size to the size column.
- Add a useful chart title and axis titles. Select the chart, then use Chart Design > Add Chart Element to add titles where available in the ribbon layout. Give the size measure a clear explanation in the chart or a note.
If you need observation names beside the bubbles, select a point series and use Chart Design > Add Chart Element > Data Labels. Then format the labels and, where the label options allow it, choose values from cells to use the names in column A. Avoid displaying every numeric value and every name if that makes the plot crowded. Excel for Mac has a similar chart-insertion workflow from the Insert tab, though ribbon placement and dialog appearance can differ. Excel for the web may have a more limited chart-editing interface; if a particular series setting is unavailable, open the workbook in the desktop app.
Make the chart easier to read
Bubble size can draw the eye more strongly than position, so use it only for a measure readers should notice. Give axes descriptive titles with units, such as “Monthly spend ($)” and “Orders (count).” A title such as “Spend, orders, and customer count by region” tells readers what the three dimensions mean more clearly than “Bubble chart.”
Consider these refinements when the chart is hard to interpret:
- Use a readable bubble color and some transparency so overlapping points remain visible. Select a data series and use the formatting pane’s fill options.
- Limit labels to points that need identification, or use a compact legend or accompanying table. Labels on every bubble can collide.
- Choose axis bounds that show the data without exaggerating small differences. Starting an axis above zero can be appropriate for an XY relationship, but state the scale clearly and avoid implying a larger change than the values show.
- Sort or filter the source data to locate an observation, but remember that sorting the rows does not change the numerical X and Y positions.
- Use consistent units and a sensible level of precision. If one row is in thousands and another is in whole units, the chart will be misleading even if it renders correctly.
Bubble area is harder to estimate than position. Readers may compare a bubble’s diameter instead of its overall area, so differences in size can be misread. Keep the size range moderate, and do not use the chart to suggest precise comparisons between close values. If accurate comparison of the third measure is important, add a table or a separate bar chart.
Common problems and what to check
If all bubbles look identical, first check that the size column contains varied numeric values and that Excel has actually assigned it as the bubble-size series. If the bubbles are enormous or tiny, inspect the range for an outlier or a value entered in different units. A single unusually large size can dominate the chart; changing the visual scale may help, but the underlying values should remain available and the treatment should be clear.
If points appear in the wrong places, verify that the X and Y series ranges are not reversed and that the rows remain paired. Each row’s X, Y, and size values must describe the same observation. Also look for blank cells, numbers stored as text, and formulas returning empty text. If Excel has treated the first row as data rather than headers, edit the series ranges so the headers are excluded from plotted values.
Overlapping bubbles are another common issue, especially when many observations share similar coordinates. Try transparency, smaller bubble sizes, selective labels, or filters. If overlap still hides the pattern, splitting the chart into smaller groups or using a scatter chart may communicate the data more honestly than squeezing everything into one plot.
Bubble chart or scatter chart?
Both chart types show the relationship between two numeric variables on X and Y axes. A scatter chart is the better default when the main question is whether the two variables move together, whether there are clusters, or whether there are outliers. Its equal-sized markers keep attention on position.
A bubble chart is useful when a third numeric measure matters and the reader can understand what size means. It is not automatically superior because it displays more information. When bubble size is constant, it adds no data; when size represents an unclear or arbitrary measure, it adds confusion. For a categorical comparison, a bar or column chart may be easier to read, while a line chart is often more suitable when the horizontal axis represents time and the sequence matters.
Frequently Asked Questions
Can I make a bubble chart with two columns in Excel?
Not with two meaningful dimensions and a meaningful bubble-size measure. Excel needs X, Y, and size values. You can add a constant size column, but if every bubble is equal, a scatter chart is usually simpler.
What are the three variables in an Excel bubble chart?
The first variable sets each point’s horizontal position, the second sets its vertical position, and the third determines bubble size. Use numeric values for all three and ensure each row refers to one observation.
How do I add names to the bubbles?
Add a label column to the worksheet, select the chart’s data labels, and use the label formatting options to draw label text from cells when available. Keep labels selective if they overlap or obscure the points.
Why are some bubbles missing?
Check for zero or blank size values, text instead of numbers, and incorrect series ranges. A point can also be hidden behind a larger bubble when several observations occupy similar positions.
Is a bubble chart better than a scatter plot for two variables?
Usually not. Use a scatter plot for two variables alone. A bubble chart earns its extra visual encoding when bubble size represents a relevant third measure.
Related
- Excel: Merge Data From Multiple Cells Into One Cell
- Excel Merge Cells Option Not Available? Causes and Fixes
- Excel Merge Cells in Each Row Without Losing Values
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: How to Hide Rows With Zero ValuesTo hide rows whose PivotTable result is zero in Excel for Microsoft 365 on Windows, open the drop-down…
- Excel Chart Maker: Create, Format, and Choose ChartsExcel’s built-in chart maker turns selected worksheet data into a chart: select a well-organized range, then choose Insert…
- Duplicate Pivot Charts and Tables in ExcelTo duplicate a PivotTable in Excel for Microsoft 365 on Windows, select the whole table with PivotTable Analyze…
- Pivot Charter School in Riverview, FL: What to KnowYes. Pivot Charter School, also known as Pivot Charter School of Tampa Bay, is a tuition-free public charter…
- Excel Pivot Table Manual Sort: Drag Items into OrderTo manually sort items in an Excel PivotTable, right-click an item label, choose Sort > More Sort Options,…
- Excel Chart: How to Add, Move, and Customize a LegendTo add a legend in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.