To make a four-quadrant scatter plot in Excel, create an XY scatter chart, then add one vertical and one horizontal line at your chosen cutoff values. The two lines divide the chart into four regions, making it easier to compare each point’s position on two numeric measures.
What a four-quadrant scatter plot shows
A four-quadrant scatter plot is an ordinary scatter chart with a vertical and a horizontal reference line crossing inside the plot area. The lines split the chart into four quadrants. Each plotted point represents a pair of values: one value determines its horizontal position, and the other determines its vertical position.
For example, a sales manager might plot sales growth on the horizontal axis and customer satisfaction on the vertical axis. Using a growth target and a satisfaction target as the dividing lines creates four useful groups: above target on both measures, below target on both, strong growth with lower satisfaction, and lower growth with strong satisfaction. The chart shows where observations fall; it does not explain why they fall there or prove that one measure causes another.
Excel does not have a separate built-in chart type called a four-quadrant scatter plot. The usual approach is to make a standard XY scatter chart and add two additional data series for the divider lines. Those lines are based on chart data, so they can stay in the right place when the chart is resized or its data changes.
Prepare the data and choose the cutoffs
Put the horizontal-axis values in one column and the vertical-axis values in another. Each row should describe one observation, and the two values on that row must belong together. Include headers so the series can be identified clearly. Both columns should contain numeric values; text categories belong in labels, not in the X or Y value ranges of an XY scatter chart.
Choose the point where each divider should cross its axis before adding the lines. A target, a business rule, or a meaningful benchmark may be more useful than the middle of the data. For a simple example, suppose A2:A5 contains X values 2, 4, 6, and 8, while B2:B5 contains Y values 3, 7, 5, and 9. A cutoff of 5 for X and 6 for Y gives two clear dividing values.
If the data itself should define the center, an average or median can be used. With the X values in A2:A5, enter this in D2 to calculate their average; the result for the example is 5.
=AVERAGE(A2:A5)
With the Y values in B2:B5, enter this in E2 to calculate their average; the result is 6.
=AVERAGE(B2:B5)
Using averages is not automatically the fairest choice. An unusually high or low observation can pull an average away from the center of most values. With the same example layout, this formula in D3 returns the X median, 5, and this formula in E3 returns the Y median, 6.
=MEDIAN(A2:A5)
=MEDIAN(B2:B5)
For skewed data or outliers, medians can provide a more representative split. If the chart is meant to measure performance against a fixed goal, use the goal instead of an average or median. The interpretation of the quadrants depends on the cutoffs, so state what they represent in the chart title, axis titles, or a note.
Create the XY scatter chart
- Select the two columns of values, including their headers. In Excel for Microsoft 365 on Windows, choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select Scatter with Only Markers.
- Check that Excel assigned the intended column to each axis. The first numeric range should be the X values and the second should be the Y values. If the axes are reversed or a series is missing, right-click the chart and choose Select Data to inspect or edit the series.
- Add clear axis titles. Select the chart, choose Chart Design > Add Chart Element > Axis Titles, then choose the horizontal and vertical titles. A title such as Sales growth (%) is more informative than simply X.
A scatter chart is important here because both axes represent numerical scales. A line chart generally treats its horizontal axis as categories, which can space observations differently and misrepresent the relationship between numeric X and Y values.
Add the vertical and horizontal divider lines
Make a small helper table with two endpoint pairs for each divider. For the example, assume both axes will run from 0 to 10, the X cutoff is 5, and the Y cutoff is 6. Enter these values in a clear area of the worksheet:
- Vertical line: X values 5 and 5; Y values 0 and 10.
- Horizontal line: X values 0 and 10; Y values 6 and 6.
The vertical series has the same X value at both endpoints, so it draws straight up and down. The horizontal series has the same Y value at both endpoints, so it draws from left to right. Set the endpoint values to the intended axis limits; otherwise a divider may stop short of the plot edges or extend beyond them.
Add each pair as its own series. Select the chart, choose Chart Design > Select Data > Add, give the series a name such as Vertical cutoff, and select its two helper cells for the series X values and its two corresponding Y cells for the series Y values. Repeat for the horizontal cutoff. In the series dialog, remove any automatically included header or label cells from the value ranges if Excel does not exclude them.
To display the lines, select the chart and choose Chart Design > Change Chart Type. Set the chart series to an XY scatter type that includes straight lines, such as Scatter with Straight Lines and Markers. Then format the original observation series to have no connecting line and visible markers. Format the two cutoff series to have solid lines and no markers. The labels in the formatting pane can differ slightly by update, but the relevant controls are under Format Data Series, including Fill & Line and Marker.
Set the axis bounds to match the helper endpoints. Right-click the horizontal axis, choose Format Axis, and set the minimum and maximum bounds; repeat for the vertical axis. For the example, use 0 and 10 on both axes. Excel may otherwise choose automatic bounds that leave a gap before a divider reaches the edge. If your data has negative values or uses a different scale, use bounds that include both the observations and the full intended divider lines.
Make the quadrants readable
Use a restrained visual hierarchy: points should remain prominent, while the divider lines should be easy to see without overpowering the data. A thin, contrasting line works well for many charts. If the two lines have different meanings, use different styles or colors and identify them in a legend or nearby note. Avoid relying on color alone when readers may print the chart in grayscale or have difficulty distinguishing colors.
Add labels such as High growth / high satisfaction only if the quadrant meanings are unambiguous. One simple option is to insert text boxes over the plot area and position one in each quadrant. In Microsoft 365 for Windows, select the chart before inserting a text box if you want it attached to the chart and moved with it. Text boxes are visual annotations, not chart data: they do not automatically relocate to the correct quadrant if axis bounds or cutoffs change. Review their positions after editing the chart.
You can also label individual points. Select the observation series, use Chart Design > Add Chart Element > Data Labels, and choose a placement. For custom labels drawn from a worksheet column, use Format Data Labels and select Value From Cells when that option is available in your Excel version. Clear X Value and Y Value if the labels should show names rather than coordinates. Too many labels can make a dense plot hard to read, so label only notable points when appropriate.
Choose a useful method for setting the split
The cutoff values should reflect the question the chart is meant to answer. Three common choices are:
- Targets or thresholds: Use these when the goal is to compare performance with a defined standard, such as a required response time or sales goal.
- Average values: Use these when comparing observations with the arithmetic center of the current dataset. Remember that outliers can influence the averages.
- Median values: Use these when the typical middle observation is more meaningful or when the data includes extreme values. A median split does not necessarily put exactly half the points in each quadrant if values tie at the cutoff.
For example, if the X cutoff is a fixed target of 5 and the Y cutoff is a median of 6, the quadrants answer two different questions: whether each observation meets the X target and whether its Y value is above or below the dataset midpoint. That is valid, but the chart should say so. If the cutoffs are intended to be comparable benchmarks, use clearly defined benchmarks on both axes.
Common problems and practical fixes
- A line stops before the chart edge: The helper endpoint does not match the axis bound, or Excel has set a different automatic bound. Extend the helper endpoints and set explicit axis bounds.
- The divider appears diagonal: One of the helper series has incorrect endpoint values or its X and Y ranges are mismatched. A vertical line needs equal X values; a horizontal line needs equal Y values.
- The data points are connected: The observation series is using a line-enabled scatter type. Format that series with no line while keeping markers visible.
- A helper series appears as extra dots: Turn off its markers and keep its line visible. Also confirm that the two endpoint pairs are included in the correct X and Y ranges.
- The chart looks wrong after filtering or changing data: Confirm the chart series ranges include the intended observations and that the cutoff values still make sense. If the cutoffs are entered as fixed numbers, they will not recalculate when the underlying data changes.
- Many points overlap: Try smaller markers, partial transparency, or labels on only a few points. Overlapping points can hide how many observations share a location.
In Excel for Mac, the same basic method applies: insert an XY scatter chart, add the helper series, and format the chart series and axes. Ribbon names and the location of chart-formatting controls can vary by update. Excel for the web supports common chart editing, but some detailed formatting controls may be more limited or arranged differently; use the desktop app if you cannot find a needed series or marker setting.
Frequently Asked Questions
Can Excel make a four-quadrant scatter plot automatically?
No dedicated four-quadrant chart type is required or provided. Create an XY scatter chart and add two line series at the chosen X and Y cutoffs.
How do I put the lines at the average?
Calculate the X and Y averages in worksheet cells with AVERAGE, then use those values as the constant coordinates for the vertical and horizontal helper series. Check the axis bounds so the lines span the plot.
Should I use the mean or the median?
Use the measure that matches your purpose. A mean is useful when the arithmetic average matters; a median is often less affected by extreme values. For a target-based comparison, use the target rather than either statistic.
Can the quadrant lines update when my data changes?
Yes, if the cutoff cells use formulas that recalculate from the data and the helper series refer to those cells. Fixed values remain fixed. If the cutoff formulas change, check that the axis limits and any text-box labels still suit the chart.
Can I label the four quadrants?
Yes. Add text boxes over the plot or use other chart annotations. Text boxes may not move to the correct quadrant automatically when the scale or cutoffs change, so review their position after edits.
Related
- Excel Spreadsheet Not Responding? Causes and Fixes
- Excel Suddenly Not Responding? Causes and Fixes
- Excel Spreadsheet Grouping Rows: How to Create and Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Hanging Indent in Word: A Simple Step-by-Step GuideTo add a hanging indent in Word, select the paragraph or paragraphs, open the Paragraph settings, and choose…
- How to Open SharePoint Files in Excel and Edit ThemTo open a SharePoint workbook in Excel, find it in the document library, select the file, then choose…
- Excel Text to Columns: Can It Split Capital Letters?No: Excel’s Text to Columns command cannot automatically split a cell wherever a capital letter appears. It splits…
- How to Add Separate Page Numbers in Word by SectionTo give different parts of a Word document their own page-number sequence, divide the document with a section…
- Outlook Export Contacts: CSV Steps and Common FixesTo export Outlook contacts, open People and choose Manage contacts > Export contacts in new Outlook or Outlook…
- Clear Outlook User Cache: What to Delete and When to Do ItTo clear the Outlook user cache, first identify which cache is causing the problem: in classic Outlook for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.