Bubble Chart in Google Sheets: Setup and Tips

Yes—Google Sheets can make bubble charts in a web browser. Arrange each item in a row with five columns for its label, X value, Y value, series, and bubble size; select the data, choose Insert > Chart, then select Bubble chart in the Chart editor.

What a bubble chart shows

A bubble chart is a way to compare items using three numeric measures at once. Each bubble has a position on a horizontal X-axis and a vertical Y-axis, while its size represents a third value. The series column can group items into categories that Sheets displays in different colors. The first column identifies the individual bubbles.

For example, a product team could plot profit margin on the X-axis and customer satisfaction on the Y-axis, then use sales revenue as bubble size. Products in the upper-right would have both higher margin and higher satisfaction; larger bubbles would represent more revenue. This makes patterns and outliers easier to spot than in a table alone.

A bubble chart is not a map or a three-dimensional chart. Its horizontal and vertical positions are still ordinary two-dimensional coordinates. Size adds another visual encoding, and series color can add a category, but neither makes the chart a substitute for precise value labels or a detailed data table.

How Google Sheets expects the data

Sheets uses five columns for a standard bubble chart. Put one item in each data row, with the columns in this order:

Label: A name or identifier for the bubble, such as a product or city.
X value: A numeric measurement that determines the horizontal position.
Y value: A numeric measurement that determines the vertical position.
Series: A category used to group or color bubbles, such as product type or region.
Bubble size: A numeric measurement used to determine the relative bubble size.

Include a header row so the purpose of each column is clear. For instance, a small table might have the headers Product, Margin, Satisfaction, Category, and Revenue. A row for one product would then contain its label, two numeric axis values, a category, and a size value. Keep the same column roles for every row; putting the size values in the series column, for example, can lead to a chart that is confusing or incorrectly interpreted.

The X, Y, and size columns should contain numbers, not numbers stored as text. The label and series columns are generally text. Use a consistent unit for each numeric measure: mixing percentages with whole-number percentages, or values in thousands with values in full units, can distort the view. The chart does not require the three measures to use the same unit, because each has a separate role, but readers need to know what each one means.

Create a bubble chart in Google Sheets

Enter the five columns in the order above, with one record per row and headers at the top.
Select the full data range, including the headers and all five columns. Avoid selecting unrelated notes or blank rows.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor.
In the Chart editor’s Setup tab, open Chart type and choose Bubble chart. If Sheets has guessed another chart type, changing it here converts the selected chart.
Check that the label, X-axis, Y-axis, series, and bubble-size fields use the intended columns. If necessary, adjust the data range or the fields in Setup.
Move or resize the chart on the sheet, then use the editor’s Customize tab to improve its titles and appearance.

For a chart you expect to update, include a reasonable range for future rows or adjust the chart’s data range when adding records. A chart based on a fixed range will not necessarily include rows added beyond that range. Keeping a clean, rectangular data table also makes later editing simpler than selecting scattered cells.

Read the positions, sizes, and colors carefully

The X and Y values determine where a bubble sits. A bubble with X value 20 and Y value 8 appears at those coordinates relative to the chart’s axis scales. The axes should have meaningful titles and, where relevant, units. Without them, a viewer may see a pattern but have no way to understand what the positions represent.

Bubble size communicates relative magnitude, not an exact value that is easy to estimate by eye. A bubble that looks twice as wide does not necessarily mean its underlying value is exactly twice as large; visual size is not a dependable substitute for reading the source data. If exact values matter, keep the data table nearby or provide labels and explanatory notes where the chart options and layout allow.

Series colors distinguish categories, not a second numeric scale. For example, color can separate departments while bubble size represents headcount. If every row has the same series value, the chart has no meaningful category distinction to show. Conversely, many categories can create a crowded legend and too many colors to compare comfortably.

Customize titles and presentation

In the Chart editor, open Customize to adjust chart appearance. Use Chart & axis titles to add a descriptive chart title and titles for the horizontal and vertical axes. A title such as Product margin and satisfaction is more informative than a generic label such as Bubble chart. Include units when they are not obvious from the data.

Use the chart style and legend controls to make the visual easier to read. A legend is useful when colors represent a small number of categories; if there is only one category, it may add little. Choose a chart size that leaves the bubbles and their labels legible, and avoid squeezing many observations into a very small area. Formatting choices should clarify the data rather than imply differences that are not present.

After changing formatting or data, check the chart against the source table. In particular, verify that the largest source values correspond to the largest bubbles, that the intended categories have the intended colors, and that the axes have not become misleadingly narrow or broad. A chart’s appearance can change when the data range changes, even if its title and formatting remain the same.

Example: comparing products

Imagine a store comparing four products. The X measure is profit margin in percentage points, the Y measure is an average customer rating, the series is product department, and bubble size is monthly revenue. A product with a higher margin and rating will sit farther toward the upper-right. A larger bubble indicates more revenue relative to the other products in the chart.

This view can help start a useful discussion: a high-revenue product with a low rating may merit investigation, while a high-rated product with a small bubble may have room to reach more customers. It does not explain why the values differ. The chart cannot establish that a rating caused revenue to rise, and it does not show whether a difference is statistically meaningful. Those questions require more context and analysis than a bubble chart provides.

For a fair comparison, use the same time period and definitions for every product. If one revenue figure is monthly and another is annual, the bubble sizes are not comparable. Likewise, an average rating based on two reviews may be less reliable than one based on hundreds; the chart will not reveal that sample-size distinction unless it is included separately.

Common problems and how to fix them

The chart is not a bubble chart: In the Chart editor, open Setup and explicitly choose Bubble chart under Chart type.
Bubbles appear in unexpected positions: Check that the X and Y columns contain the intended numeric fields, and confirm that the editor is using those columns rather than labels or categories.
All bubbles look alike: Review the bubble-size column for real numeric values and meaningful variation. If all values are identical or nearly identical, the chart will not show much size contrast.
Categories do not appear as expected: Check the series column for consistent category names. Accidental spelling differences can split what should be one category into several.
Some rows are missing: Check the selected data range and look for blank rows or values stored as text. Expand the range if new records fall outside it.
The chart is hard to interpret: Add clear axis titles, use understandable labels, reduce unnecessary categories, or show fewer observations. A chart with many overlapping bubbles may hide rather than reveal patterns.

Also inspect unusual values before interpreting the picture. One very large size value can make other bubbles seem tiny, and one extreme X or Y value can stretch an axis so most observations bunch together. Do not remove a valid outlier just to improve the appearance; first determine whether it is a data error or a real observation, then explain any filtering or separate views you use.

When to use a bubble chart instead of another chart

Choose a bubble chart when the position of each item on two numeric measures and its relative size are all important. It can be a useful exploratory view for products, regions, campaigns, or projects. A scatter chart is often clearer when the main question is the relationship between two numeric variables and a third measure is unnecessary. A bar chart is usually easier when the task is to compare exact values across a modest number of named categories.

Bubble charts become less effective when there are many observations, labels overlap, size values are too similar, or the audience needs precise comparisons. Consider filtering to a meaningful subset, splitting categories into separate charts, or pairing the chart with a sorted table. Google Sheets offers other chart types for different questions; do not choose a bubble chart merely because the data has several columns.

Excel also supports bubble charts, but its chart-creation interface and data-selection workflow differ from Google Sheets. Instructions for Excel ribbon commands should not be followed as if they were Sheets menu paths. In Sheets, the browser-based workflow is Insert > Chart and then Chart type in the Chart editor.

Frequently Asked Questions

How many columns do I need for a Google Sheets bubble chart?
A standard bubble chart uses five: label, X value, Y value, series, and bubble size. The label identifies an item, the two axis values set its position, the series groups it, and the size value controls its relative bubble size.

Can I make a bubble chart with only three columns?
Not as a standard five-field bubble chart unless you provide the other required roles. Add a label, a series category, and a numeric size column as needed. If your goal is only to plot two numeric measures, a scatter chart may be a better fit.

Can bubble size show a category such as small, medium, or large?
Bubble size is intended to represent a numeric measure. You can use a numeric code for categories, but the sizes would suggest a magnitude that may not exist. A series category or separate chart is generally a clearer way to distinguish groups.

Why are the bubble labels or colors wrong?
Check that the first column contains the intended identifiers and that the fourth column contains the intended series categories. Then review the field assignments and selected range in the Chart editor’s Setup tab. Repeated or inconsistent category text can also affect how the groups appear.

Can I make a bubble chart in Google Sheets on a phone?
The steps here describe Google Sheets in a web browser, where the Chart editor has the Setup and Customize controls described above. The mobile app has a different interface and may not expose the same chart-editing controls, so use the browser version for this workflow when the needed option is unavailable in the app.

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.