To create a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric columns—X values, Y values, and bubble sizes—select those columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Add labels and titles afterward so readers can identify what each bubble represents.
What a bubble chart shows
A bubble chart is a variation of an XY scatter chart. Each observation appears as a circle positioned by two values: one determines its horizontal location and another its vertical location. A third value controls the circle’s size. This lets you compare three numeric measures at once, while color can distinguish groups or categories.
For example, a retailer might plot advertising spend on the horizontal axis, conversion rate on the vertical axis, and total sales as bubble size. A product with high spend and a high conversion rate appears toward the upper right; a larger bubble indicates more sales. The chart can reveal clusters, outliers, and trade-offs that are hard to see in a table.
Bubble size is not a fourth axis, and a bigger circle does not mean a higher X or Y value. It represents the third measure visually. Because people compare circle areas less precisely than positions on a scale, use bubble charts to show broad differences and patterns—not to make readers estimate exact values from bubble diameters.
Prepare the data in three columns
Put one observation on each row and give the three plotted fields clear column headings. Keep any text names, such as product names or city names, in a separate column for labels. For instance, a small product comparison could look like this:
- Product: Cedar, Maple, Birch, and Pine
- Ad spend (X): 10, 15, 20, and 25
- Conversion rate (Y): 2.5, 3.1, 2.8, and 4.0
- Sales (bubble size): 40, 70, 55, and 100
Here the numbers are illustrative; the units and scales should suit your own data. Keep the X, Y, and size values numeric, not numbers stored as text. Include a header row, avoid blank rows inside the data, and make sure every row’s values refer to the same observation. A stray blank cell or mismatched row can produce missing or misleading points.
Bubble sizes should be positive values that make sense for comparison. A zero-sized value may be invisible, while negative values cannot sensibly be represented as circle area. If your third measure includes zero or negative numbers, consider whether another chart type or a transformed, clearly explained measure would communicate the data more honestly. Do not substitute arbitrary bubble sizes just to make every point visible.
Create the bubble chart
In the Windows desktop version of Excel for Microsoft 365, select the three numeric columns, including their headings, and insert the chart:
- Highlight the X, Y, and size columns, including the headers. If they are next to each other, select the full rectangular range.
- Open the Insert tab.
- Choose Insert Scatter (X, Y) or Bubble Chart, then choose Bubble. Excel also offers 3-D Bubble, but the standard 2-D chart is usually easier to read because perspective can make sizes and positions harder to compare.
- Check that the chart places the intended measure on each axis and uses the third measure for bubble size. Add a chart title and axis titles before sharing it.
Excel tries to infer how the selected columns belong together. If the result has the wrong series or axes, select the chart and use Chart Design > Select Data. In the dialog, add or edit a series and assign the intended ranges to Series X values, Series Y values, and Bubble size. The series name can refer to a header cell. The ranges should cover corresponding rows and should not include the header as a plotted number.
To compare groups, you can create a separate series for each group, with its own X, Y, and size ranges. Excel gives series different colors, which makes categories easier to distinguish. Keep the groups meaningfully limited; too many colors and overlapping circles can make the chart more confusing than the table.
Add product or category labels
By default, Excel may display the X value, Y value, or bubble size in data labels, but those numbers do not necessarily tell a reader which product a point represents. To use names from your worksheet, select the bubbles, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Value From Cells and choose the cells containing the names. If you do not want extra numbers beside each name, clear the X Value, Y Value, or Bubble Size options as needed.
For the example above, select the four product-name cells—Cedar through Pine—as the label range. Review the result: overlapping labels can hide one another, especially when bubbles are crowded. You can drag individual labels to improve placement, shorten long names, or label only the points that matter most. If Value From Cells is unavailable in your version or chart interface, use numeric labels or add names in a nearby table rather than implying labels are supported in every Excel edition.
Format the chart so it is readable
Click the chart to reveal the chart tabs, then use Chart Design and Format to adjust its appearance. A clear title should state the comparison, while axis titles should include both the measure and its units—for example, “Ad spend ($ thousands)” and “Conversion rate (%)”. Without units, a scale such as 10 to 25 is difficult to interpret.
- Set sensible axis bounds. Right-click an axis and choose Format Axis. Adjust minimum and maximum bounds when doing so clarifies the data, but avoid cropping the scale in a way that exaggerates small differences.
- Use consistent number formats. Format percentages as percentages and currency as currency. Choose a manageable number of decimal places.
- Choose distinct, accessible colors. Use a small palette with enough contrast, and do not rely on color alone if categories need to be identified.
- Keep gridlines restrained. A few light gridlines can help readers estimate positions; heavy lines and decorative effects compete with the data.
- Check the legend. A legend is useful when color identifies multiple series. For a single series with point labels, it may add little.
You can resize the chart by dragging a corner handle. Give labels room, and check the chart at the size at which it will be viewed or printed. A chart that looks clear when enlarged may become unreadable in a report or on a small screen.
Understand bubble size and overlap
Bubble charts are best for spotting relative patterns, not reading precise values from circle size. A circle’s visual area is what readers tend to compare, so its size should represent the third variable in a consistent way. Do not manually enlarge selected bubbles to draw attention unless that change is clearly explained; doing so breaks the chart’s scale.
Overlap is a common limitation. When two observations have similar X and Y values, the larger bubble can cover the smaller one, hiding a data point. You can reduce the chart’s plotted size, show fewer observations, use transparent fills, split categories into separate charts, or label only key points. Excel’s bubble-size scale can also be adjusted: right-click a bubble, choose Format Data Series, and look for the scale or size settings in Series Options. The available controls may vary by Excel version.
Before drawing a conclusion, check whether a cluster reflects a real relationship or simply many points plotted close together. Also consider the underlying numbers: a chart cannot correct inconsistent units, incomplete records, or a misleading choice of bubble-size measure.
Fix common bubble-chart problems
- The chart shows the wrong axes: Use Chart Design > Select Data, edit the series, and assign the correct X, Y, and bubble-size ranges. Confirm that each range covers the same observations.
- Excel made several unexpected series: Reopen Select Data and edit the series rather than relying on automatic interpretation. Remove unwanted series and create one series with the three intended numeric ranges.
- Bubbles are missing: Check for blank cells, text-formatted numbers, zeros, negative size values, or rows outside the selected range. A zero-size bubble may be too small to see.
- The bubbles look nearly identical: The size values may have a narrow range, or the chart’s size scale may need adjustment. Check the original values before changing formatting so you do not hide meaningful differences.
- Names do not appear: Confirm that Value From Cells is enabled and that the selected label range has one cell per plotted point. Turn off unwanted numeric label options if they clutter the chart.
- The chart is hard to interpret: Add axis titles and units, simplify the palette, reduce overlapping labels, and consider whether a scatter chart would be clearer.
When to use a scatter chart instead
A bubble chart is useful when the third measure adds important context, such as population, revenue, or volume. If bubble size does not help answer the question, use a standard scatter chart instead. Scatter charts focus attention on the relationship between X and Y and avoid the extra visual complexity of differently sized circles.
A bar or column chart is often better for comparing a short list of categories, especially when the exact ranking matters. A line chart is generally more suitable when the horizontal axis represents time and the order of observations is meaningful. These alternatives are not interchangeable: choose based on the question, the type of data, and whether the audience needs to compare positions, trends, or category totals.
Excel for Mac also provides chart insertion and formatting controls from the Insert and chart-design tabs, though ribbon layout and some options can differ from Windows. In Excel for the web, available chart-formatting controls may be more limited; if a needed option such as cell-based labels is missing, open the workbook in desktop Excel and finish formatting there.
Frequently Asked Questions
Can a bubble chart have more than one data series?
Yes. Each series needs its own matching X values, Y values, and bubble-size values. Use Chart Design > Select Data to add or edit series, and use color or a legend to distinguish groups.
Why are my bubble sizes not proportional to the numbers?
Excel scales the bubbles for display, and the visible area is more useful for comparing values than the diameter alone. Check the bubble-size input range and series size settings; do not judge the values by measuring circle widths.
Can I put names inside the bubbles?
You can add data labels and, in supported desktop versions, use Value From Cells to select a range of names. Excel positions labels near the bubbles, and crowded charts may still need manual label adjustments.
Can bubble sizes be negative?
Negative values do not represent meaningful circle areas. Use a positive size measure, or choose a different chart that can show positive and negative values directly.
Is a 3-D bubble chart better?
Usually not for precise comparison. Three-dimensional effects can make bubble size and position harder to judge. Use the standard 2-D Bubble option unless the perspective serves a specific, clear purpose.
Related
- Free Excel Meal Plan Template: Build a Weekly Planner
- Fixing Broken Links in Excel: Find and Repair Them
- Find Same Names in Two Excel Columns
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create an Org Chart From Excel Data in ExcelYes. In Microsoft Excel for Microsoft 365 on Windows, you can create an org chart with Insert >…
- How to Remove a Trendline from an Excel ChartTo remove a trendline from an Excel chart in Microsoft 365 for Windows, click the trendline to select…
- Excel Line Chart with Two Lines: Setup, Labels, and FixesTo make an Excel line chart with two lines, arrange the shared category labels in one column and…
- Excel Pivot Table: How to Remove Zero ValuesTo remove zero-valued results from an Excel PivotTable, open the drop-down for the row or column field, choose…
- How to Make a Graph in Excel the Easy WayTo make a graph in Excel, put your labels and numbers in a simple table, select the data,…
- Excel Series Trendline: Add, Choose, and Interpret OneTo add a trendline to a data series in Excel for Microsoft 365 on Windows, select the chart,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.