Yes. In Excel, make a bubble chart from three data fields—an X value, a Y value, and a bubble-size value—then set the horizontal and vertical axes to cross at your chosen thresholds. Those crossing lines divide the plot into four quadrants, while each bubble’s position and size communicate three measures at once.
What a four-quadrant bubble chart shows
A bubble chart is a type of XY scatter chart. Each data point gets a position from its X and Y values, and a third value controls the bubble’s size. Adding two reference lines where the axes cross divides the chart into four regions. The chart is useful when you want to compare many items against two measures and show an additional measure, such as volume, at the same time.
For example, a sales team could plot product profitability on the X axis, customer satisfaction on the Y axis, and annual sales volume as bubble size. If the axes cross at the company’s target profitability and satisfaction scores, products fall into four groups: above both targets, below both, or above one and below the other. The chart does not create those categories for you; the thresholds and their meaning need to be chosen and explained.
The four regions are sometimes called quadrants even when the crossing point is not zero. That is fine: in a business chart, the meaningful dividing point may be a target such as 50% margin or a score of 70, rather than the numeric origin.
Prepare the worksheet data
Arrange the source data in columns with one row per item. Use a clear header row and numeric values for the three plotted measures. For example, a product comparison might use columns for Product, Margin, Satisfaction, and Sales volume. Product names are useful for labels, but the chart’s positional and size inputs must be numeric.
- X: the measure displayed along the horizontal axis, such as margin.
- Y: the measure displayed along the vertical axis, such as satisfaction.
- Size: a positive numeric measure that determines the relative bubble size, such as units sold.
- Label: an optional text field identifying each point, such as the product name.
Check that the rows match across all columns: a product’s X value, Y value, size, and name must stay on the same row. Remove or resolve missing values before charting. Also check the units and scale. A satisfaction score from 1 to 5 plotted beside a margin percentage from 0 to 100 may be valid, but the axes will have very different ranges and need readable labels. Bubble size values should generally be positive; zero or negative sizes cannot communicate a meaningful bubble area.
Create the bubble chart in Excel
In Excel for Microsoft 365 on Windows, select the numeric X, Y, and size data, including their headers, and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. If Excel assigns the fields incorrectly or does not include all the data, define the series explicitly:
- Select the chart, then choose Chart Design > Select Data.
- In the Select Data Source window, choose Add to create a series, or select an existing series and choose Edit.
- Set the series name to the header or a cell containing the series name. Set Series X values to the X data cells, Series Y values to the Y data cells, and Bubble size to the size data cells.
- Choose OK to apply the series, then close the data selection window.
Use the Bubble option rather than the 3-D Bubble option unless you have a specific reason to add the visual depth effect. Three-dimensional shading can make relative sizes and positions harder to compare. On Excel for Mac, the chart options and formatting pane may be arranged differently, but the same chart type and series fields are used. Excel for the web has fewer chart-formatting controls; if you cannot set axis crossings or labels as needed, open the workbook in the desktop app.
Set the two quadrant thresholds
Choose the threshold values before formatting the chart. In a typical target-versus-performance chart, the X threshold might be a minimum acceptable margin and the Y threshold a satisfaction goal. The crossing point must be within the displayed axis ranges, or the relevant dividing line may appear at an edge or outside the plot.
To set the vertical dividing line, select the horizontal (X) axis and open Format Axis. Under Axis Options, find Vertical axis crosses, choose Axis value, and enter the X threshold. To set the horizontal dividing line, select the vertical (Y) axis, open Format Axis, and under Horizontal axis crosses, choose Axis value and enter the Y threshold. The wording in the pane can vary slightly with chart selection and Excel updates, but the key is to edit the crossing setting for the opposite axis.
Set sensible minimum and maximum bounds for both axes in the same Format Axis pane. If Excel automatically chooses bounds that place a threshold near an edge, set fixed bounds that include the threshold and give the data room around it. For instance, if X values run from 20 to 80 and the target is 50, bounds of 0 and 100 may make the dividing line easier to interpret than a tightly cropped range. Use bounds that preserve the context rather than exaggerating small differences.
Label and format the quadrants
Axis titles explain the measures, but quadrant names explain the decision or category. Add axis titles with Chart Design > Add Chart Element > Axis Titles. Give each axis a title that includes units when necessary, such as “Profit margin (%)” or “Satisfaction score (1–100).” A chart title should state the subject and, if useful, the period being measured.
For point labels, select the bubbles and use Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Value From Cells and choose the cells containing item names. Clear the X Value, Y Value, or Bubble Size label options if they clutter the chart. If Value From Cells is not available in the version you are using, use a legend for a small number of categories or add labels manually with text boxes; manual labels need updating if the points move.
Place quadrant names in the plot area with text boxes, or use a short subtitle or note to describe what each region means. Keep the labels away from bubbles and make sure they remain readable if the chart is resized. Use a consistent bubble color unless color represents another clearly defined category. If you use color as a fourth visual variable, include a legend and avoid relying on color alone to convey important distinctions.
Read the chart with a concrete example
Suppose a company compares four products using margin, satisfaction, and monthly sales. The thresholds are 40% margin and 70 satisfaction points. Product A has 55% margin, a score of 82, and sales of 900 units; it appears in the upper-right quadrant and has a relatively large bubble. Product B has 25% margin, a score of 78, and sales of 500; it appears upper-left, meaning satisfaction is above target while margin is below it. Product C has 50% margin, a score of 58, and sales of 1,200; it appears lower-right and may deserve attention because its bubble is large despite missing the satisfaction target.
That interpretation depends on the definitions. “Upper-right” means only that both plotted values exceed the selected thresholds; it does not prove that the product is successful overall. A larger bubble means a larger size value, not necessarily better performance. Include a note explaining the time period, the threshold source, and whether higher or lower values are desirable. If lower values are better for one measure, such as defect rate, make that explicit or transform the metric so the quadrant labels do not imply the opposite.
Common problems and practical fixes
- The chart shows the wrong locations: Reopen Chart Design > Select Data and confirm the X and Y ranges are assigned in the right order. Excel may interpret selected columns differently than intended.
- The quadrant lines are missing: Check that you changed the crossing value on the relevant axis and that the threshold lies between the axis minimum and maximum. Also confirm the chart is a bubble or XY scatter chart, not a category-based chart.
- Some bubbles are too large or hide others: A few high size values can dominate the view. Check for mistaken units or outliers, and consider a different size measure or a separate chart. Do not alter source values merely to make the picture look balanced.
- Labels overlap: Label only the most important points, enlarge the chart, or use a table beside it for exact values. Too many labels can make a useful plot unreadable.
- The chart seems to say more than the data supports: State the thresholds, units, and date range. A bubble chart presents relationships, but by itself it does not establish why two measures move together.
When to use another chart
A four-quadrant bubble chart works best when each item has meaningful numeric X, Y, and size values, and the audience can distinguish the bubbles. If there are only two numeric measures, an XY scatter chart with threshold lines is often clearer. If bubble size adds little information or there are many closely packed items, use a scatter plot, a labeled table, or separate small charts instead.
For many categories, a two-by-two matrix with names in the appropriate cells can be easier to scan, especially when exact quadrant membership matters more than the numeric distance between items. A bubble chart is strongest when the reader needs both approximate position and a sense of relative magnitude. Consider accessibility too: provide labels or a data table so readers do not have to infer meaning from color or bubble size alone.
Frequently Asked Questions
Can Excel make a four-quadrant bubble chart automatically?
Excel can create the bubble chart, but it does not automatically decide meaningful quadrant thresholds or name the regions. Set the axis crossing values yourself and add labels or explanatory text for the four areas.
Do the axes have to cross at zero?
No. Set the crossing values to the thresholds that matter for your analysis. A target-based chart commonly crosses at values such as 40% and 70, provided those values are inside the displayed axis ranges.
What does bubble size represent in Excel?
Bubble size represents the third numeric series assigned to the chart. Use it for a clearly defined measure, such as sales volume, and explain the units. The displayed bubbles are useful for relative comparison, not as precise area measurements.
Can I show product names instead of numbers on the bubbles?
Yes. Use data labels and, where available, choose Value From Cells in the Format Data Labels pane, then select the name cells. If the option is unavailable in your Excel version, add a legend or use text labels as a workaround.
Why is a bubble missing or hard to see?
Check that its X, Y, and size cells contain valid numeric values and that the size is positive. A small bubble may also be hidden behind a larger one at a similar position; label the point or adjust the chart layout without changing the underlying data.
Related
- Excel Named Range Lookup: Find and Use Named Ranges
- Excel Named Range Greyed Out? Causes and Fixes to Try
- Excel Named Data Range: Create, Use, and Manage Names
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Power Pivot in Excel: Enable It and Fix Missing TabsTo enable Power Pivot in Excel for Microsoft 365 on Windows, go to File > Options > Add-ins,…
- Excel Not Making Graphs Correctly? Fix Common CausesIf Excel is not making graphs correctly, first check that the chart uses the intended data range, treats…
- Excel Line Chart Zero Values: What to ChangeExcel plots a numeric zero as a real data point, so a line chart will show it on…
- Excel Pivot Chart Slicers: How to Add and Use ThemAn Excel PivotChart slicer is a set of clickable filter buttons for a PivotTable and its connected PivotChart.…
- Excel Pivot Bar Chart: Sort Categories AscendingTo sort an Excel PivotChart’s bar categories in ascending order, sort the matching field in its PivotTable: open…
- How to Embed an Excel Chart in PowerPoint and Edit ItTo embed an Excel chart in PowerPoint, select the chart in Excel, copy it, then in PowerPoint choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.