To create a 4-quadrant scatter plot in Excel, make an XY scatter chart from your X and Y columns, then add one horizontal and one vertical line at your chosen thresholds. The two lines divide the plot into four regions, making it easy to compare points such as performance against a target or cost against quality.
What a 4-quadrant scatter plot shows
A four-quadrant scatter plot is a regular scatter chart with a horizontal reference line and a vertical reference line. Each observation appears as a point located by two numeric measurements: its X value determines its horizontal position, and its Y value determines its vertical position. The reference lines split the chart into four areas.
For example, a team might compare customer satisfaction on the X-axis with response speed on the Y-axis. If both targets are 70, a point above and to the right of the lines meets both targets; one below and to the left misses both. The other two quadrants show cases that perform well on one measure but not the other. The plot does not determine what counts as good: the threshold values and the meaning assigned to each quadrant depend on the question being asked.
Excel does not have a separate chart type called a four-quadrant scatter plot. You build it from a standard XY scatter chart and add the dividing lines as extra data series. This method keeps the lines tied to numeric axis values, so they can be placed at meaningful thresholds rather than merely drawn by eye.
Prepare the data and choose thresholds
Put each observation on one row, with a name or ID in the first column and its two numeric measurements in the next columns. For a simple example, use A1:C6 for five items: column A contains the item name, column B contains its X score, and column C contains its Y score. Use values from 0 to 100, such as A with scores 35 and 60, B with 45 and 82, C with 65 and 75, D with 78 and 55, and E with 58 and 90.
Choose the thresholds before adding the lines. In this example, set the vertical divider at X = 50 and the horizontal divider at Y = 70. Those might represent a minimum acceptable score and a target, but they could instead be a budget limit, a service-level goal, or another decision boundary. Use thresholds that are defensible for the purpose of the chart; the midpoint of an axis is not automatically a meaningful cutoff.
Check that both measurement columns contain numbers, not numeric-looking text, and that each X value belongs to the corresponding Y value on the same row. Include the column headings when selecting data, but exclude blank rows and totals. A scatter chart needs numeric X and Y values; unlike a line chart, it positions points according to the actual numeric spacing between X values.
Insert the scatter chart
- Select the X and Y data, including their headings. For the example, select B1:C6. If you also want the names available for data labels, keep those in column A; they do not need to be part of the initial selection.
- On the Windows ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select Scatter with only Markers. The exact icon may appear in the Charts group as a small scatter-chart symbol.
- Check that Excel assigned the X scores to the horizontal axis and the Y scores to the vertical axis. If you selected only B1:C6, Excel will normally use the first numeric column as X and the second as Y.
- With the chart selected, use Chart Design > Add Chart Element to add axis titles and a chart title. Name the axes with the actual measures and units, such as Satisfaction score and Response score, rather than leaving readers to guess.
If Excel interprets the columns incorrectly, select the chart and choose Chart Design > Select Data. Select the series and choose Edit, then set Series X values to the X-score cells and Series Y values to the Y-score cells. A scatter plot uses paired numeric ranges; selecting a category label column as the X range can produce an unexpected chart.
Add the horizontal and vertical quadrant lines
Create two small helper tables in unused worksheet cells. For example, enter X horizontal and Y horizontal in E1:F1, then enter 0 and 70 in E2:F2 and 100 and 70 in E3:F3. These two coordinates form a horizontal line at Y = 70, extending from X = 0 to X = 100. For the vertical line, enter X vertical and Y vertical in H1:I1, then enter 50 and 0 in H2:I2 and 50 and 100 in H3:I3.
Add the horizontal helper values as a new series:
- Select the chart, then choose Chart Design > Select Data > Add.
- Give the series a name such as Horizontal threshold. Set Series X values to E2:E3 and Series Y values to F2:F3, using the range selector in the dialog if needed. Select OK.
- Repeat the process for the vertical line, using H2:H3 for Series X values and I2:I3 for Series Y values. Name it Vertical threshold.
The series ranges should refer to the two endpoint cells only, not to their headings. If your helper tables are on another sheet, use the range selector to select the cells on that sheet. Excel may initially show the new series as two markers joined by a line or as markers only; you can format each series next.
These endpoint values assume the chart axes run from 0 to 100. If your data uses a different scale, use the intended minimum and maximum of the X-axis for the horizontal line, and the intended minimum and maximum of the Y-axis for the vertical line. For instance, if X runs from 1 to 5, use 1 and 5 as the horizontal line’s X endpoints. Using endpoints outside the displayed axis range can make a line appear incomplete or not appear at all.
Set axis bounds and format the lines
For a clean, symmetrical example, set both axes to run from 0 to 100. Right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and enter 0 for the Minimum bound and 100 for the Maximum bound. Repeat for the vertical axis. Setting bounds explicitly helps the helper lines reach the edges and prevents Excel from changing the displayed range when the data changes.
Click a threshold series to select it, then open its formatting options. In the Format Data Series pane, set Marker Options to None so the two endpoint markers disappear, and choose a visible solid line under Fill & Line. Repeat for the other threshold series. A contrasting but restrained color or a dashed line can distinguish the thresholds from the data without overpowering the points. If the chart is crowded, reduce marker size or use some transparency for the data markers.
Make the threshold values clear in the chart title, axis labels, a legend, or nearby text. A line without a stated value can be ambiguous, especially if a reader sees the chart outside its original report. You can rename the helper-series headings to readable names and use the chart legend, or add short text labels such as Target: 70. Avoid relying on color alone to explain which line is which.
Label points and interpret the four regions
In the example, A is below both thresholds, B is below the X threshold but above the Y threshold, C and E are above both, and D is above X but below Y. This gives each quadrant an observable meaning without changing the underlying data. The upper-right region represents items meeting both thresholds; the lower-left represents items missing both. The upper-left and lower-right regions show mixed results.
To identify points by name, select the data markers and use Chart Design > Add Chart Element > Data Labels. In the Format Data Labels pane, choose Value From Cells if that option is available in your Excel version, then select the names in A2:A6. Clear X Value and Y Value if you want names without the numbers. For a small number of points, labels can make the chart much easier to read. For a large set, labels may overlap; consider labeling only important points or using a data table beside the chart.
Interpret the quadrants as a classification aid, not as proof that one measure causes the other. A scatter chart displays association and relative position; it does not explain why a point is where it is. A point just above a cutoff and one far above it occupy the same quadrant even though their margins differ. When that distinction matters, include labels, a scale, or a separate analysis of the distance from each threshold.
Common problems and fixes
- The dividing line does not reach the chart edges: Check the helper-series endpoints against the axis bounds. If the axis minimum is 10, an endpoint of 0 may fall outside the visible plot. Set suitable axis bounds or change the endpoints.
- The line appears diagonal: Confirm that both endpoints use the same Y value for the horizontal line, and both endpoints use the same X value for the vertical line. Also verify that the X and Y ranges were not reversed.
- The line is only a pair of dots: Select the helper series and choose a chart style or formatting option that displays a connecting line. Then set its markers to None if you want a plain divider.
- The chart changes scale after adding a series: Excel may have adjusted automatic bounds to include the helper points. Set Minimum and Maximum bounds explicitly for both axes, and keep helper endpoints within those bounds.
- Points are bunched together or oddly spaced: Confirm that the chart type is XY Scatter, not a line chart. A line chart treats horizontal positions as categories, whereas a scatter chart uses numeric spacing.
- Labels overlap: Use fewer labels, enlarge the chart, or move labels individually. Do not shrink the chart so much that the data points and threshold lines become difficult to distinguish.
Keep the chart useful as data changes
The helper points are ordinary worksheet data, so you can move a threshold by changing its repeated coordinate. For example, changing both Y values in the horizontal helper table from 70 to 75 moves that line to the new target. If you adjust the axis bounds, revisit the helper endpoints as well. With a fixed 0-to-100 scale, the example endpoints remain suitable.
If you expect to add many observations, convert the data range into an Excel table with Insert > Table and use a chart based on the table so new rows can be included as the table expands. Verify the chart’s series range after adding rows, particularly if the helper data is nearby. Keep the helper tables separate from the main observations so they are not accidentally plotted as real items. A chart linked to a maintained data range is easier to update than a chart whose series ranges must be repaired after every change.
For a presentation or report, add a short note defining each cutoff and the direction of better performance. If higher values are worse for one measure, the quadrants still work, but their descriptions need to reflect that. For example, high cost and high quality may not have the same interpretation as high satisfaction and high speed. Include units and the time period represented by the data when those details affect comparisons.
Excel for Mac and Excel for the web
In Excel for Microsoft 365 on Windows, the main process uses Insert, Chart Design, Select Data, and Format Axis. Excel for Mac offers the same general chart construction approach, though ribbon placement and dialog appearance can differ by release. Excel for the web also supports scatter charts and chart formatting, but some detailed formatting controls and workflows may be arranged differently or be less complete than in the desktop app. If you cannot find a particular series or label option in the web version, open the workbook in desktop Excel to use the full chart controls.
The key is not a particular version-specific command: the chart must be an XY scatter chart, and each reference line must be a separate series with two numeric endpoints. Once those series are in place, you can adjust their values and formatting in the worksheet and chart.
Frequently Asked Questions
Can Excel make a four-quadrant chart automatically?
No dedicated four-quadrant chart type is required. Insert a standard XY scatter chart and add horizontal and vertical reference-line series at the values that define your quadrants.
Should I use the average or median as the dividing line?
Use a cutoff that fits the question. A business target or specification may be more meaningful than a statistical midpoint. If you want to split observations based on the sample, an average or median can be a deliberate choice, but state which one you used and remember that it can change when the data changes.
Can the quadrant lines be placed at values other than the middle?
Yes. Set the shared Y coordinate of the horizontal line to the chosen Y threshold and the shared X coordinate of the vertical line to the chosen X threshold. The two cutoffs do not need to be equal or centered.
Why does Excel show a diagonal line instead of a divider?
One or both helper series probably have mismatched endpoint values. A horizontal line needs identical Y values at its two endpoints; a vertical line needs identical X values. Check the series ranges and the order of the X and Y values.
Can I use text categories on the X-axis?
A scatter chart requires numeric X values because horizontal position represents numeric distance. If your X measure is a text category, assign numeric codes only if their spacing has a valid meaning, or consider a different chart type that treats categories as labels.
Related
- Can You Group Rows in Excel for Sorting? Here’s How
- Can You Hide a Column in Excel From View?
- Location Heat Map in Excel: Create One Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Cell Locked When Scrolling? Causes and FixesIf a cell or row stays visible while you scroll in Excel, the usual cause is Freeze Panes,…
- Excel Goal Seek Algorithm: How It Finds a SolutionExcel Goal Seek is a one-variable numerical tool: it repeatedly changes an input cell until a formula cell…
- Forgot Excel Sheet Password? Safe Recovery OptionsIf you forgot the password for a protected Excel worksheet, Excel has no built-in command to reveal or…
- Google Sheets Inventory Template: Build a Simple TrackerYes. You can make a practical Google Sheets inventory template with columns for each item, its location, quantities…
- Power Query Excel: Split a Column into PartsIn Excel for Microsoft 365 on Windows, split a column in Power Query by opening the query, selecting…
- Excel Box and Whisker Plot Examples With Setup TipsExcel box-and-whisker plot examples include comparing test scores across classes, delivery times across routes, or monthly measurements across…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.