Yes. In Excel for Microsoft 365 on Windows, put each item’s numeric X position, numeric Y position, and bubble size in separate columns, then select the data and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Use positions such as 1, 2, and 3 to represent the categories in your matrix.
What a Matrix Bubble Chart Shows
A matrix bubble chart combines a two-dimensional chart with a third measure shown by the size of each bubble. The horizontal axis places items along one measure, the vertical axis places them along another, and the bubble size represents a value such as volume, cost, risk, or number of cases. It is useful when you want to compare many items by both position and relative scale.
The word matrix usually refers to the way the plot is divided into regions, such as a two-by-two priority matrix or a three-by-three performance grid. Excel does not have a separate chart type called a matrix bubble chart. You create a standard bubble chart, map your matrix categories to numbers, and add labels and gridlines so the plotted positions read like a matrix.
For example, a project-priority chart might use urgency for the X position, business impact for the Y position, and estimated annual users for bubble size. Projects in the upper-right are both urgent and high impact; a larger bubble there represents a project affecting more users. This lets readers see position and scale together, although labels and bubble overlap need attention.
Prepare the Data for a Matrix
A bubble chart needs three numeric values for every point: an X value, a Y value, and a size value. Put one item on each row and use a separate column for its label. A simple table could look like this:
- Project: Atlas, Beacon, or Cedar.
- Urgency: a numeric X coordinate, such as 1 for low, 2 for medium, and 3 for high.
- Impact: a numeric Y coordinate using the same 1-to-3 scale.
- Users affected: a positive numeric value that determines relative bubble size.
Keep the category mapping consistent. If 1 means low and 3 means high on the X axis, the Y axis should use a clearly documented scale as well. For a five-level scale, use values from 1 to 5 and make the axis bounds and major unit match that scheme. The numbers are coordinates, not measurements that Excel understands as words; the chart will not know that 1 means low unless you add labels or explain it.
Use numeric values for all three plotted measures. Text such as Low, Medium, and High is useful in the label column, but it cannot serve as the bubble chart’s coordinate. Check that blank cells, text-formatted numbers, or missing size values are not preventing rows from plotting as intended. Avoid negative bubble sizes; use a sensible positive scale for quantities that can otherwise be zero.
Create the Bubble Chart
- Arrange the columns with a header row, for example Project, Urgency, Impact, and Users affected. The X and Y columns should contain the coordinates, and the final numeric column should contain the size values.
- Select the three numeric columns, including their headers. You can also select the label column, but Excel may initially use it in an unexpected way; the numeric series is what determines bubble positions and size.
- On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the ordinary Bubble option for circles, not 3-D Bubble, which can make comparisons harder to read.
- Check the result. If Excel assigned the wrong columns, right-click the chart and choose Select Data. Edit the series so the X values point to the coordinate column, the Y values to the other coordinate column, and the bubble size to the size column. Series names can use the header cells.
- Give the chart a descriptive title and add axis titles if they clarify what the two dimensions mean. The chart should make it obvious which direction represents higher values.
Excel for Mac also provides bubble charts through Insert > Chart; select Bubble in the chart choices. The ribbon and formatting panes can look different from Windows. Excel for the web can display and edit many charts, but if a formatting option or data-label control is missing, open the workbook in the desktop app.
Make the Chart Read Like a Matrix
By default, Excel treats the axes as numeric scales. For a three-level matrix, set each axis to a minimum of 0.5, a maximum of 3.5, and a major unit of 1 so the plotted values 1, 2, and 3 sit within the chart area. Select an axis, open Format Axis, and adjust the bounds and units under Axis Options. For a five-level matrix, the corresponding bounds can be 0.5 and 5.5, with a major unit of 1.
Use major gridlines to make the cells easier to distinguish. Select the chart, use the chart elements control to add gridlines, or use the Chart Design ribbon’s chart-element controls. Because a bubble chart’s points are positioned at category coordinates, gridlines at whole-number intervals help readers identify the intended row and column. If you need clear quadrant divisions between low and high, add divider lines at the chosen thresholds and label the regions; make sure the line positions agree with the axis scale.
Axes will still show numeric ticks unless you add category labels. One practical approach is to retain the numbers and place text boxes near the axes or within the matrix to explain the levels. Another is to use data labels that include category names. Be cautious with manually positioned labels: they can drift when the chart is resized, when axis bounds change, or when the workbook is opened on a differently sized screen.
Label and Format the Bubbles
Bubble labels help readers identify individual items. In current desktop Excel, select the chart, add data labels, then open Format Data Labels. If available, choose Value From Cells and select the cells containing the project or product names. Clear X Value, Y Value, or Bubble Size if those numbers would clutter the labels. You can also show only the values that are useful to the reader.
Choose a restrained color scheme. One color works well when the chart has a single set of items; use separate series or a meaningful color distinction only when it encodes an additional category. Include a legend or direct explanation if color carries meaning. Set some transparency when bubbles overlap, and use a clear outline so smaller circles remain visible against larger ones.
Excel scales bubbles relative to the size values in the series, but circles can still be difficult to compare precisely. A bubble with a value twice as large does not necessarily look twice as wide; the size is conveyed by the circle’s area. Keep the scale meaningful, and do not resize individual bubbles by dragging them, since that breaks the relationship between the display and the source data.
Worked Example: A Project Priority Matrix
Suppose a team rates projects from 1 to 3 for urgency and business impact, where 1 is low and 3 is high. The bubble size represents the number of affected users. Atlas is at urgency 3 and impact 3 with 900 users; Beacon is at 2 and 3 with 300 users; Cedar is at 1 and 2 with 150 users. Each row becomes one plotted point, with the user count in the bubble-size column.
Set both axes to show the full 1-to-3 scale, then label the axes Urgency and Business impact. Add project names as labels and a note that bubble size represents users affected. Atlas should appear in the upper-right and be visibly larger than Beacon and Cedar. The visual can reveal that a high-priority item is also high-volume, but it does not decide priority for you: the ratings and the choice of bubble-size measure are assumptions that need to be explained.
If two projects share the same urgency and impact scores, their bubbles will overlap. A smaller point may become hard to see, even though it is present in the data. You can make the chart more readable by filtering the view, using transparency, or slightly separating points only if you disclose that the positions have been adjusted. For a strict decision matrix, keeping the exact coordinates is usually more important than eliminating every overlap.
Common Problems and Practical Fixes
- The chart has one bubble or no bubbles: confirm that the X, Y, and size ranges contain numeric values and that the series ranges cover the same number of rows. Use Select Data to correct the series assignments.
- The axes look too broad: set fixed minimum and maximum bounds that fit the matrix, rather than leaving a large automatic range. Leave enough space around the outer category positions for the bubbles.
- Labels show coordinates instead of names: use the cell-based data-label option where available, or add labels selectively. A chart with every numeric field displayed can quickly become unreadable.
- Large bubbles hide small ones: use transparency, adjust the plotted size values to a defensible common scale, or separate coincident points only with a clear note. Do not conceal overlap by changing the data silently.
- The chart seems to imply too much precision: category scores such as low, medium, and high are ordinal ratings. A position of 3 is not necessarily three times a position of 1. Explain the scoring scale and avoid interpreting the spacing as a measured difference unless the data support that interpretation.
When to Use a Different Chart
A bubble matrix is most useful when the X and Y positions matter and a third numeric measure adds genuine context. If the main goal is to compare values across named categories, a bar chart is often easier to read. If the key message is the difference between two measures and the third measure is not important, a standard scatter chart may be clearer.
For a fixed grid in which each cell contains one score or status, a heat map made with cell formatting may be more suitable. It keeps categories in a table and uses color to show intensity. A bubble chart is not a true table: bubbles can overlap, categories are encoded as numeric coordinates, and size comparisons are approximate. Choose the format that best supports the question rather than adding bubbles simply because the chart looks more detailed.
Frequently Asked Questions
Can Excel make a bubble chart with text categories on the axes?
Not directly as category axes. Bubble charts require numeric X and Y coordinates. Assign numbers to the categories, then use tick explanations, labels, or text boxes to show what those numbers mean.
How do I show names instead of numbers on the bubbles?
Add data labels, open Format Data Labels, and choose Value From Cells if the option is available in your desktop Excel version. Select the name cells and turn off numeric values you do not want displayed.
Can I create a 2×2 matrix bubble chart?
Yes. Map the two dimensions to numeric coordinates, set suitable axis bounds, and mark the chosen low/high thresholds with divider lines or labels. Explain where the boundary falls so the four regions are unambiguous.
Why are some bubbles missing or hidden?
Check for blank, text, zero, or invalid size values and verify the series ranges. A bubble may also be covered by another point with the same or nearby coordinates. Transparency or selective filtering can reveal overlaps.
Can bubble size represent a percentage?
Yes, if the percentages are numeric and the size measure is explained. Excel uses the values to scale circles; keep the source values consistent and avoid mixing percentages with counts in the same size series.
Related
- How to Unlock Microsoft Excel: Sheets, Files, and Editing
- Unlock Scroll Lock in Excel With a Keyboard Shortcut
- How to Unhide a Sheet in Excel With a Shortcut
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Stacked Waterfall Chart Excel Template: A Setup GuideExcel does not have a separate chart type called a stacked waterfall chart. To make one in Microsoft…
- Agile Gantt Chart in Excel: Plan Sprints and ReleasesYes. You can make an Agile Gantt chart in Microsoft Excel by listing work items, adding start and…
- Excel Pivot Table: How to Filter by a List of ValuesFor a quick filter, open the PivotTable field’s drop-down, clear Select All, check the values you want, and…
- Excel Histogram Limits: Bin Counts, Data, and WorkaroundsExcel does not have one universal histogram limit that applies to every workbook: the practical ceiling depends on…
- Best Free Excel Gantt Chart Templates: 5 PicksFor most people, Vertex42’s Gantt Chart Template is the best free Excel Gantt chart template: it gives you…
- Accounting Graphs and Charts: How to Choose the Right ViewAccounting graphs and charts turn financial records into visual summaries that make trends, comparisons, and unusual results easier…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.