Google Sheets Bubble Chart: Create and Customize One

Yes—Google Sheets can make bubble charts in a web browser. Arrange your data in five columns for a label, an X value, a Y value, a group or series, and a bubble-size value; select the data, choose Insert > Chart, then select Bubble chart in the Chart editor.

What a bubble chart shows

A bubble chart displays each row of data as a circle positioned by two numeric values. The horizontal position represents the X value, the vertical position represents the Y value, and the size of the circle represents a third numeric measure. A group or series column can distinguish categories by color. This lets you compare three numerical measures and a category in one view.

For example, a product team could plot products by price and monthly sales, use bubble size for units returned, and color bubbles by product category. A bubble toward the upper right would represent a product with both a higher price and higher sales than one toward the lower left; its size would separately indicate returns. The chart does not decide whether that pattern is meaningful, though. Choosing sensible measures and explaining them clearly are still your responsibility.

A bubble chart is a variation of a scatter chart. A scatter chart uses point positions to show the relationship between two numeric variables; a bubble chart adds size to show another variable. It can be useful when a table has several measures per item, but the extra visual dimension also makes it easier to overload the chart.

Prepare the data in the right layout

Put one item or observation on each row, with a header at the top of each column. A typical Google Sheets bubble-chart table looks like this:

Column A — label: a short name for the item, such as a product or city.
Column B — X value: a number that determines horizontal position, such as price.
Column C — Y value: a number that determines vertical position, such as monthly sales.
Column D — group or series: a category, such as product type, used to separate groups visually.
Column E — bubble size: a nonnegative number, such as units returned or customer count.

For instance, a row might contain "Alpha," 20, 75, "Outdoor," and 12. That represents an item named Alpha at X = 20 and Y = 75, assigned to the Outdoor group, with a size value of 12. Use actual numeric cells for the three measures. Numbers imported as text, blank values, or text such as "12 units" may prevent Sheets from plotting a point as intended.

Keep the header row in the selected range so Sheets can use the headings in the chart. Avoid merged cells, subtotals, and extra notes inside the data block. If some rows have missing X, Y, or size values, decide whether to complete or exclude them rather than assuming the chart will interpret missing data the way you intend. A size value of zero may be invisible or effectively too small to notice, so check whether zero means a real absence or simply missing information.

Create a bubble chart in Google Sheets

Open the spreadsheet in Google Sheets in a web browser and arrange the data in the layout above.
Select the header row and all data rows, including the five columns.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually on the right.
In the editor’s Setup tab, open the Chart type menu and choose Bubble chart. If Sheets has guessed another chart type, changing it here replaces that chart type.
Check the selected data range and the chart’s field assignments. Confirm that the label, X, Y, group or series, and size values are being read from the intended columns. If the result looks wrong, adjust the range or the available field selections rather than rearranging values blindly.
Close the Chart editor when the plotted points look right. To reopen it later, double-click the chart.

Sheets may infer headings and columns from the selected range, but automatic setup is not a guarantee that every field is assigned correctly. Look at the chart against a few known rows: if a product with a high X value does not appear farther right than one with a low X value, check the X assignment and the source cells. This simple check can reveal swapped columns or values stored as text.

Format labels, colors, and axes

Use the Customize tab in the Chart editor to refine the chart. Available controls depend on the chart and its data, but common options include chart and axis titles, legend placement, series appearance, and axis settings. Give the chart a title that states what is being compared, and use axis titles that include units. "Price (USD)" and "Monthly sales (orders)" tell readers more than "X" and "Y."

The group or series field helps readers distinguish categories, and the legend explains the categories. Keep category names short and limit the number of groups where possible. If the series colors are hard to tell apart, or the legend is crowded, simplify the categories or use a clearer visual treatment. Do not assume that readers can identify groups from color alone; clear labels and an understandable legend matter, especially when a chart is printed or viewed by someone with color-vision differences.

Axis bounds can change how much of the plot area the data uses. Tight limits may make small differences appear dramatic, while very wide limits can compress the bubbles into one corner. Choose limits that suit the comparison and do not hide relevant points. If labels collide or the chart becomes busy, enlarge the chart, shorten item names, or remove labels that are not necessary. A chart that is technically correct can still be difficult to read.

Choose bubble sizes that readers can interpret

The size column should represent a meaningful third measure, not an arbitrary ranking added just to make the chart look more varied. Explain what the size means in the chart title, a note, or nearby text. If a bubble represents population, for example, say so; readers should not have to infer whether a large circle means a large population, a high score, or a more important item.

Bubble size is a visual cue, not a precise reading tool. People can compare a very small bubble with a very large one more easily than they can estimate the exact value of either from its appearance. Keep the underlying values in the sheet and use a table or data labels when precise comparisons matter. Be especially cautious when one size value is much larger than the others: the largest bubble can dominate the view and make smaller points hard to see.

Also consider overlap. When two items have similar X and Y values, their bubbles may cover one another, hiding a point or making a combined area look like one observation. You can reduce the number of plotted rows, separate categories into clearer groups, or use a different chart for dense data. Do not alter the measures simply to spread bubbles apart unless the change is clearly identified and appropriate for the analysis.

Common problems and how to fix them

The chart is blank or has too few bubbles: Check that X, Y, and size cells contain numbers, that the selected range includes the data rows, and that required values are not empty. Imported numbers may be stored as text.
The bubbles appear in the wrong places: Review the X and Y column assignments and compare a few plotted points with their source rows. A swapped axis or an incorrect data range is a common cause.
All bubbles look nearly the same size: Check that the size field points to the intended numeric column and that its values actually vary. A narrow range of values can also make size differences difficult to see.
Colors or legend entries do not match expectations: Check the group or series column for inconsistent spelling, extra spaces, and unintended categories. For example, "Retail" and "Retail " may not be treated as the same text value.
Some labels or points are hard to see: Look for overlapping points, a crowded legend, or axis limits that leave little room for the data. Make the chart larger or simplify it before adding more labels.

When editing the source table, make sure the chart’s data range still includes new rows. If a chart is shared or copied into another spreadsheet, verify that its source range and category labels still refer to the expected data. A chart can remain visible even when its data range no longer represents the full table.

Bubble chart versus scatter chart and Excel

Choose a scatter chart when the relationship between two numeric variables is the main point and a third size measure would distract. Choose a bubble chart when bubble size adds a useful measure and the number of plotted items is manageable. If exact values, many observations, or detailed category comparisons matter more than a compact overview, a table or another chart type may communicate the information better.

Google Sheets and Microsoft Excel both offer bubble charts, but their chart editors and options are not identical. The steps in this guide use Google Sheets in a browser: Insert > Chart, then select the chart type in the Chart editor. In Excel, creating and formatting a bubble chart uses Excel’s chart tools and ribbon, so do not assume Sheets menu names or field controls apply there. If a collaborator opens a Sheets file in Excel, review the chart after conversion because chart appearance and editable settings can differ between spreadsheet applications.

Frequently Asked Questions

Can Google Sheets make a bubble chart?
Yes. Select a suitable data range, choose Insert > Chart, and select Bubble chart in the Chart editor. The data needs label, X, Y, group or series, and size information for a standard bubble-chart setup.

What data columns do I need for a bubble chart?
Use a label column, two numeric columns for horizontal and vertical positions, a group or series column, and a numeric size column. Include headers and keep one observation per row so the chart can associate each item’s values.

Can a Google Sheets bubble chart show labels?
The first column provides the labels associated with the bubbles, and chart options may let you adjust series or labeling appearance. Whether every label is readable depends on the chart settings and how crowded the data is. For exact identification in a dense chart, keep a matching data table nearby rather than forcing every name into the plot.

Why are all the bubbles the same size in Google Sheets?
Confirm that the size values are in the intended column, are numeric, and differ from one another. If their range is very small or the bubbles overlap, size differences may be difficult to see even when the source values are valid.

Is a bubble chart the same as a scatter chart?
No. Both use horizontal and vertical positions to represent two numeric variables, but a bubble chart also uses circle size to represent a third measure. If that extra measure does not improve the explanation, a scatter chart is usually simpler to interpret.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.