Microsoft Excel Bubble Chart Template: Build and Customize

Charts & pivot tables · Updated November 20, 2026

Microsoft Excel does not provide one universal bubble-chart template, but you can build a reusable chart in minutes: arrange each item’s X value, Y value, and bubble size in separate columns, select the numeric data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Format the chart and save it as a chart template to reuse its appearance with other data.

What an Excel bubble chart template includes

A bubble chart plots three numeric measures for each data point. The first measure positions the point horizontally, the second positions it vertically, and the third determines the bubble’s size. A chart template can preserve the chart type and many formatting choices, such as colors, fonts, axis settings, and labels, so you do not have to style a new chart from scratch.

It helps to distinguish a chart template from an Excel workbook template. A chart template is typically saved as a .crtx file and applies a chart design to data. A workbook template, commonly saved as .xltx, can contain worksheets, sample data, formulas, and charts. Choose a chart template when your goal is to reuse the look of a bubble chart; choose a workbook template when you want a repeatable reporting layout as well.

Excel’s built-in chart options give you the starting point, but a template is useful when the default chart does not suit your report. You might standardize a team’s colors, set consistent axis bounds, or include labels that identify each bubble. A template does not turn a two-measure dataset into a three-measure one: the source still needs usable X, Y, and size values.

Prepare the data before inserting the chart

Put one observation on each row, with a header for each column. For example, a project-priority chart could use cost on the X axis, expected impact on the Y axis, and the number of customers affected as bubble size:

Project Cost (thousands) Impact score Customers affected
Alpha 20 8 450
Beacon 35 6 250
Cedar 15 5 120
Delta 50 9 700

The project names are identifiers, not plotted measurements. Keep the three plotted columns numeric and in consistent units. In this example, higher impact is better, but higher cost is worse; that makes the positions meaningful only if the axes are clearly titled. The bubble-size values should also represent a quantity that readers can interpret. Do not use unrelated values simply to make some circles look larger.

  • Use a single row per item and avoid blank rows inside the data range.
  • Use numeric cells for X, Y, and size. Text such as “20k” may be read as text rather than a number.
  • Use a positive size measure and explain its unit, such as people, orders, or dollars.
  • Keep the label column beside the values so you can use it for data labels later.

Bubble size is a visual encoding, not a precise substitute for reading the underlying number. Readers estimate circle size less accurately than position on an axis, so bubbles work best when the size differences are useful but do not need to communicate exact values on their own.

Create the bubble chart in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, follow these steps:

  1. Arrange the data in columns as described above. For a simple one-series chart, select the X, Y, and size columns, including their headers. If you include the project-name column in the selection, Excel may not use it as plotted data; you can add labels afterward.
  2. Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select Bubble. Choose 3-D Bubble only if its appearance suits the presentation; the chart still represents X, Y, and bubble size, not a fourth or additional measure.
  3. Check that Excel assigned the intended columns correctly. If needed, right-click the chart and choose Select Data to inspect or adjust the series. In the Edit Series dialog, set the series X values, series Y values, and bubble size range to the correct cells.
  4. Give the chart a descriptive title and add axis titles. With the chart selected, use Chart Design > Add Chart Element to add titles, a legend, or other chart elements.

Excel usually works best when the selected data is a clean, contiguous block. If your columns are separated by other fields, select the chart and use Select Data to assign the ranges explicitly. For separate groups, add a series for each group and check each series’ X, Y, and size ranges. A legend identifies series, not individual bubbles within one series.

On Excel for Mac, the chart type is also available from the Insert tab’s chart controls, though the ribbon layout can differ by release and window width. Excel for the web can create and edit many charts, but some chart-formatting and template-management options may be limited compared with the Windows desktop app. If a command is missing, open the workbook in desktop Excel rather than assuming the chart data is incompatible.

Format axes, bubbles, and labels for readability

Start with the axes. Add titles that include units, such as Cost (thousands of dollars) and Impact score. Check whether Excel’s automatically chosen minimum and maximum values make the differences easy to understand. To change an axis, right-click it and choose Format Axis, then adjust the bounds or number formatting in the pane. Avoid cropping values in a way that exaggerates small differences; if you set a nonzero minimum, make the choice clear.

To change the bubbles’ appearance, select a bubble series and use the formatting options for fill, outline, and transparency. Transparency can help when bubbles overlap, although too much makes the chart faint. You can also adjust the series’ bubble-size scaling in the Format Data Series pane. Test the result with the full data range: a single unusually large value can make the remaining bubbles look almost identical.

To show project names, right-click a bubble series and choose Add Data Labels. Then open the data-label formatting options and select Value From Cells, if available, to choose the cells containing the names. You can clear X Value, Y Value, or Bubble Size if those numbers would clutter the chart. If Value From Cells is not offered in your Excel build, use a version that supports it or label key points manually; do not assume the default labels are the category names.

Keep the legend only if it explains multiple series. For a single series, a legend entry such as Series 1 adds little information. Use direct labels selectively, and consider moving labels or enlarging the chart if they overlap. A concise note that explains what bubble size means can prevent readers from mistaking the circles for decoration.

Save and reuse a chart template

After formatting the chart in Excel for Microsoft 365 on Windows, right-click the chart and choose Save as Template. Choose a location and save the .crtx chart-template file. The template saves the chart’s design and chart-type choices; it does not replace or package the source data as a general reusable dataset. Keep the template in a location you can find again, especially if you will use it on another computer.

To apply the design to a different dataset, first create or select the new chart, then use Chart Design > Change Chart Type and choose Templates to pick the saved design. You can also look for saved templates in the Templates category when inserting a chart. The exact display can vary with Excel’s version and where the template file is stored. If the template is not listed, browse to the saved .crtx file or copy it to an accessible location.

Review the result after applying the template. A color scheme or axis bound that made sense for the original data may not fit the new range. Check the plotted X, Y, and size values, labels, axis units, and title each time. A template is a formatting shortcut, not a guarantee that every chart is analytically correct.

If you need a full reporting file rather than just a chart design, save a workbook template instead. Remove sensitive or outdated sample data, leave clear instructions for the next user, and save the workbook as an Excel template. This is a separate workflow from saving a chart as .crtx.

Common bubble-chart problems and fixes

  • The chart looks like a scatter plot with identical dots: Check that the bubble-size range was assigned and contains numeric values. A missing size range or values that are too similar can make bubbles appear alike.
  • The points are in the wrong places: Use Select Data to verify the X and Y ranges. A swapped X and Y column changes the story, even though Excel still draws a valid chart.
  • Some bubbles are missing: Check for blank, text, or unsuitable size entries and confirm that the chart’s source range includes every intended row. Also look for points that overlap exactly or are hidden behind much larger bubbles.
  • Labels show numbers instead of names: Add data labels, then select Value From Cells and the label range where available. The first column is not guaranteed to appear automatically as bubble labels.
  • The chart is hard to interpret: Add axis titles and units, explain bubble size, reduce unnecessary gridlines, and use a smaller number of series or labels. Too many bubbles can obscure the pattern.

A frequent misconception is that a bubble chart automatically displays a third data value as a readable label. It uses that value to size circles; it does not necessarily print the value beside each point. Another is that a 3-D Bubble chart adds a third positional axis. It does not: the bubble’s size is already the third encoded measure, and a 3-D visual effect can make comparisons harder.

When to choose a different chart

Bubble charts are useful when the relationship between two numeric measures matters and a third measure adds context. They are less suitable when precise comparison of many categories is the main task, when most values are similar, or when bubbles overlap heavily. A scatter chart is often clearer when the third measure is not important. A bar chart is easier to read when the main goal is comparing category values, and a line chart is generally more appropriate when the horizontal axis represents ordered time.

Alternatives can also make a crowded bubble chart more useful without changing the underlying analysis. Split a large set into small charts, filter to a meaningful subset, or use color to distinguish a limited number of groups. If color represents another variable, add a clear legend and use a color scheme that remains distinguishable for readers with color-vision differences. Do not encode too many categories through size, position, and color at once.

Excel is not the only way to create a bubble visualization. Other spreadsheet and data-visualization tools may offer different labeling or interactivity options, but the same data requirements apply: a defensible X measure, Y measure, and size measure. If you share the chart with someone who cannot use the workbook, consider exporting a clear image or PDF and retaining the workbook when recipients need to inspect or update the data.

Frequently Asked Questions

Does Excel have a built-in bubble chart template?
Excel includes a Bubble chart type, but that is a chart option rather than a ready-made template for every dataset. You can format a bubble chart and save its design as a .crtx chart template for reuse.

What data do I need for an Excel bubble chart?
You need three numeric measures for each item: an X value, a Y value, and a bubble-size value. A separate text column can hold names for labels, but it does not replace any of the three plotted measures.

How do I show names on the bubbles?
Add data labels to the series, open the label-formatting options, and choose Value From Cells when that option is available. Select the cells containing the names, and turn off numeric label choices that you do not want displayed.

Can I use a bubble chart template with new data?
Yes. Save the formatted chart as a .crtx template, create a chart from the new dataset, and apply the template through the chart-type template options. Then check the series ranges, labels, and axis settings because the new data may need different formatting.

What is the difference between a chart template and a workbook template?
A chart template saves a chart design for reuse. A workbook template can include a whole worksheet structure, sample data, formulas, and charts. Use the chart template for consistent chart styling and a workbook template for a repeatable report or data-entry file.

Related

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.