Excel for Microsoft 365 does not include a native packed bubble chart. You can make a standard bubble chart from three numeric measures, but for true circle packing—circles sized by a value and arranged without x- and y-axis meaning—you will need a different chart type, an add-in, or a manual workaround.
What a packed bubble chart shows
A packed bubble chart represents items as circles. The area or apparent size of each circle corresponds to a measure, such as revenue, population, or units sold. A packing algorithm places the circles close together, usually without overlap. Unlike a conventional chart, the circles’ positions generally do not encode two additional numeric variables; the layout is mainly a way to fit and compare the circles.
For example, a retailer might use circle size to show sales by product category. A large circle indicates a larger value, while smaller circles represent lower sales. Color can add another distinction, such as region or product group. This format can make relative size patterns easy to scan, but it is less suited to reading exact values or comparing similar-sized items precisely.
The term can be confusing because Excel does offer a chart called a bubble chart. That chart is not packed: each bubble is positioned by an x-value and a y-value, and a third value controls its size. The two chart types both use circles, but their layouts answer different questions.
Does Excel support packed bubble charts?
Excel’s built-in chart types include a standard bubble chart, but not a native packed bubble chart with automatically arranged circles. Excel also offers options such as Treemap and Sunburst for hierarchical data. Those are not packed bubble charts either, although they can be useful when the goal is to show parts of a whole or nested categories.
If you have found instructions that say to choose “Packed Bubble” from Excel’s chart gallery, check which product or add-in they refer to. That chart type is available in some other charting tools, and third-party Excel add-ins may provide it. Availability, licensing, data handling, and compatibility depend on the specific add-in, so check its documentation and your organization’s rules before installing one.
A static image imported into a worksheet is another possibility, but it is not an editable Excel chart. If the source data changes, you would generally need to recreate or update the image outside Excel. For a chart that needs to refresh with worksheet data, an add-in or a different built-in chart is usually more practical.
Create a standard bubble chart in Excel
If your data has two meaningful numeric coordinates as well as a size measure, Excel’s bubble chart may be the right choice. For example, a team could plot customer satisfaction on the x-axis, retention rate on the y-axis, and customer count as bubble size. In this chart, position is meaningful; it is not an automatic packing arrangement.
- Arrange the data in columns, with one row per item. Include a numeric x-value, a numeric y-value, and a numeric bubble-size value. Keep a separate column for item names if you want to use names as labels.
- Select the three numeric columns, including their headings if present.
- On Windows, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the regular Bubble option rather than 3-D Bubble unless you have a specific reason to use the 3-D style.
- Check that Excel assigned the intended columns to the x-values, y-values, and bubble sizes. If it did not, use Chart Design > Select Data to edit the series.
- Add a title and axis titles when they help explain the measures. To add labels, select the series, use Chart Design > Add Chart Element > Data Labels, and then open the data-label options. In the Format Data Labels pane, use Value From Cells if that option is available in your Excel build, and select the cells containing item names.
On Excel for Mac, the chart is also inserted from the Insert tab, but the chart gallery and formatting panes can be arranged differently. Look for the Scatter or Bubble chart options and use the chart formatting controls to set labels and series data. Excel for the web has more limited chart-editing controls than the desktop app, so a detailed chart setup may be easier in Excel for Microsoft 365 on Windows or Mac.
Prepare data that makes sense
For a standard bubble chart, every plotted item needs an x-value, a y-value, and a size value. Those values should be numeric and use consistent units within each measure. For instance, do not mix percentages recorded as 0.25 and 25 in the same y-value column. A separate label column can contain names such as product, store, or department.
Before charting, decide what each dimension means and make the units clear. A chart of advertising spend against sales, with profit as bubble size, can be meaningful if all three measures refer to the same period and comparable entities. A size column containing text, blanks, or values from a different time frame will make the result confusing or incomplete.
- Use one row per point and avoid merged cells in the data range.
- Use clear column headings, and check for blank or nonnumeric values in the plotted columns.
- Choose a size measure that is meaningful and nonnegative. Zero or negative values cannot communicate bubble area in the same intuitive way as positive values.
- Keep category labels concise. Long labels can overlap, especially when many bubbles are close together.
Make a bubble chart easier to read
Bubble charts can become cluttered quickly, particularly when there are many points or a wide range of sizes. Use axis titles and number formats so readers can tell whether values mean dollars, percentages, or counts. If the bubbles cover one another, consider reducing the number of points, changing the axis ranges, or splitting the data into separate charts. A chart with fewer, well-explained marks is often more useful than one that tries to show every record at once.
Bubble size also needs careful interpretation. People tend to compare a circle’s diameter, but the value is represented by the circle’s area. As a result, doubling the underlying value should correspond to twice the area, not twice the diameter. Avoid manually resizing individual bubbles to make a chart look balanced; doing so breaks the relationship between the data and the visual encoding.
When labels are important, label only the points that need explanation or use a small accompanying table. Displaying every label can obscure the bubbles. If values are close together, a data table or sorted bar chart may communicate the ranking more accurately than circles.
Choose an alternative when packing is essential
If the circle-packing layout itself is important, consider a charting tool or a vetted Excel add-in that specifically supports packed bubbles. Confirm that it can use your data structure, refresh when values change, export or share the result in the format you need, and work with your version of Excel. For workplace files, also check whether the tool sends data to an external service and whether that is permitted.
For other goals, a built-in Excel chart may be a better fit:
- Treemap: Use Insert > Insert Hierarchy Chart > Treemap to show hierarchical categories as rectangles sized by value. It is useful for nested groups such as division, department, and product, but it uses rectangles rather than circles.
- Sunburst: Use Insert > Insert Hierarchy Chart > Sunburst when the levels of a hierarchy matter. Rings show levels, so it can make parent-child relationships clearer than an ungrouped bubble display.
- Bar chart: Use a bar chart when the main task is comparing or ranking values. Bars are usually easier to compare accurately than circles, particularly when values are similar.
- Standard bubble chart: Use it when x-position and y-position have real numeric meanings and the third measure is useful as size.
These options are not interchangeable. Choose based on the question: hierarchy, ranking, two-variable position, or a packed display of relative magnitudes. For a simple “which categories are largest?” comparison, a sorted bar chart may be clearer than any bubble chart.
Common problems and misconceptions
A common mistake is assuming a regular bubble chart will arrange circles into a compact cluster. It will not: Excel plots the x- and y-coordinates supplied in the series. If those coordinates are arbitrary, the chart may look scattered, but that does not make it a packed bubble chart. Inventing coordinates solely to make the bubbles appear packed can also imply relationships that the data does not support.
Another issue is confusing bubble size with a second value axis. In a standard bubble chart, the size measure affects the marker size; it is not plotted as a third axis. Make this distinction clear in the title, legend, or labels. Also inspect the chart after changing the data range: new rows may not be included automatically if they fall outside the chart’s source range.
Finally, do not expect color alone to explain the chart. Use a legend or direct labels when colors represent categories, and check that the chart remains understandable when printed or viewed by someone who cannot distinguish the colors easily. If exact comparisons are central, include the values or use a more precise chart type.
Frequently Asked Questions
Can I make a packed bubble chart in Excel without an add-in?
Not as a native, automatically packed chart. You can create a standard bubble chart, use a built-in alternative such as Treemap, or draw circles manually, but manual placement does not automatically update as a packed layout when values change.
What is the difference between a bubble chart and a packed bubble chart?
A standard bubble chart positions each point using x- and y-values and uses a third value for bubble size. A packed bubble chart arranges circles by a packing layout; their positions usually do not represent two numeric variables.
Can I use text labels on an Excel bubble chart?
Yes. Add data labels and, where supported in your Excel build, use the Format Data Labels pane’s Value From Cells option to use a worksheet range for labels. You can keep the numeric values for plotting while showing names beside the bubbles.
Is a Treemap the same as a packed bubble chart?
No. A Treemap uses nested rectangles to show hierarchical categories and relative values. It can be a useful built-in alternative, but it does not create circles or the same visual layout.
When should I use a bar chart instead?
Use a bar chart when readers need to compare exact values or rank many categories. Length is generally easier to compare than circle area, so bars often communicate small differences more clearly.
Related
- Microsoft Excel Contact List Template: Setup and Tips
- Microsoft Excel: How to Convert Text to Numbers Safely
- Excel: How to Compare Two Workbooks
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pie Chart Labels: Use the Legend or Slice Text?In Excel, a pie chart legend identifies each slice by matching its color to a category name; it…
- Excel Waterfall Chart Split Bar: How to Show ComponentsExcel’s built-in Waterfall chart cannot split one bar into stacked segments. To show what makes up a change,…
- Excel Pivot Chart Pie Chart: Multiple Columns ExplainedYes, you can make a pie PivotChart in Excel, but a pie chart can show only one data…
- Room Chart in Google Sheets: Build One Step by StepYes. You can make a room chart in Google Sheets by arranging cells as rooms or seats, then…
- Selecting the Chart Area in Excel: A Practical GuideTo select the chart area in Excel for Microsoft 365 on Windows, click a blank part of the…
- Excel Pivot Table: Filter Dates by YearTo filter an Excel PivotTable by year, group its date field: right-click any date in the PivotTable, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.