Creating a Four-Quadrant Scatter Plot in Excel: Steps

How-to basics · Updated November 18, 2026

To create a four-quadrant scatter plot in Excel, put each item’s X value and Y value in two columns, select those columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Add a vertical and horizontal threshold at the values that divide your data; you can do this by setting where the axes cross or, for greater control, by adding two helper data series as lines.

What a four-quadrant scatter plot shows

A four-quadrant chart is a standard XY scatter chart with one vertical and one horizontal dividing line. The lines split the plotting area into four regions, making it easier to compare two measures for each item. The chart itself does not calculate categories or decide what counts as high or low: the chosen X and Y thresholds determine the quadrants and should reflect the question you are trying to answer.

For example, a customer analysis might plot annual spending on the X axis and satisfaction score on the Y axis. A vertical line at the average spending value and a horizontal line at the average satisfaction value create four groups: above-average spending and satisfaction, high spending but lower satisfaction, lower spending but higher satisfaction, and below-average results on both measures. The same method can compare project impact with effort, product growth with margin, or employee performance with another numeric measure.

Excel calls the underlying chart type an XY scatter chart because both axes represent numeric values. That matters: a line chart treats its horizontal labels as categories, while a scatter chart positions points according to their actual X values. Use a scatter chart when the horizontal measure is numeric and the distance between values matters.

Prepare the data and choose the cutoffs

Arrange the source data so that each observation has a numeric X value and a numeric Y value. Put descriptive names in a separate column if you want to label individual points. For instance, columns A, B, and C could contain Customer, Spending, and Satisfaction, with one customer per row. Keep the headers in the first row and the observations in matching rows below them.

Before drawing the chart, decide how to calculate the two dividing values. Common choices include:

  • A target or benchmark: Use a meaningful fixed value, such as a service target of 80 points or a spending threshold set by the business.
  • The mean: Divide observations above and below the arithmetic average. A few unusually large values can pull the mean away from the middle of the data.
  • The median: Divide the observations around the middle value, which is less affected by extreme values than the mean.
  • A deliberate decision boundary: Choose a threshold based on a policy or action, such as the minimum score that qualifies for follow-up.

Use the same units and scale consistently. If satisfaction is scored from 1 to 5, do not accidentally enter a threshold of 80 unless the values have been converted to a percentage scale. A quadrant is only as useful as the meaning of its dividing lines.

Insert the scatter chart

  1. Select the X and Y data, including their headers, but exclude text labels unless you intend to use them as a separate series. If the columns are not adjacent, select the first range and then use Ctrl-click to select the second range on Windows.
  2. Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select the basic Scatter option, usually shown with markers and no connecting lines.
  3. Check that Excel assigned the intended column to each axis. Select the chart, choose Chart Design > Select Data, select the series, and choose Edit if necessary. Set Series X values to the X-number range and Series Y values to the Y-number range.
  4. Add clear axis titles. Select the chart, choose Chart Design > Add Chart Element > Axis Titles, and enter names with units where useful, such as Annual spending ($) and Satisfaction (score out of 100).

For a single set of observations, the chart should usually contain one data series. If Excel creates separate series for each column or plots the first column as Y values, correct the series ranges in Select Data rather than rebuilding the whole chart.

Add dividing lines by setting the axes to cross

For a quick chart, the existing axes can serve as the quadrant dividers. Right-click the vertical value axis and choose Format Axis. In the Format Axis pane, under Axis Options, set Horizontal axis crosses to Axis value and enter the desired horizontal threshold. Then right-click the horizontal value axis, choose Format Axis, and set Vertical axis crosses to Axis value, entering the desired vertical threshold. The wording and pane layout can vary slightly between Excel builds, but the two settings control where the axes meet the opposite numeric scale.

This method is convenient when you want the actual axes to mark the thresholds. It can also move axis labels into the middle of the plot, where they may overlap points. In the Format Axis pane, adjust the label position if needed, or use helper lines instead so the regular axes can remain at the chart edges. The crossing values must be inside the visible bounds of the corresponding axes; a crossing value outside the displayed range will not divide the visible plot as expected.

Axis crossing changes the placement of the axes, not the data. It does not automatically calculate an average, median, or target. Enter the threshold you have chosen, and check that Excel has interpreted it in the correct units.

Draw independent threshold lines with helper series

Helper series are often the clearest option because the lines can be formatted independently of the axes. First decide on fixed minimum and maximum values for both chart axes. For example, if spending is shown from 0 to 100 and satisfaction from 0 to 10, a vertical divider at spending 60 can run from (60, 0) to (60, 10). A horizontal divider at satisfaction 7 can run from (0, 7) to (100, 7).

Enter each line’s two endpoint coordinates in unused cells. Keep each line’s X endpoints together and its Y endpoints together. To add the vertical line, select the chart, choose Chart Design > Select Data > Add, give the series a name such as Spending threshold, and select the two X endpoint cells and the two Y endpoint cells in the appropriate boxes. Repeat for the horizontal line with its own endpoint pairs. The endpoints are the chart’s numeric coordinates, not screen positions.

After adding the series, select each helper series and choose Chart Design > Change Chart Type. Set the helper series to Scatter with Straight Lines, if needed, then format the series so it has a visible line and no markers. Right-click a helper series and choose Format Data Series to adjust its line color, width, or dash style. Keep the original observation series as markers so the thresholds remain distinct from the data.

Set the main axes’ minimum and maximum bounds to match the endpoint ranges. Otherwise, Excel may expand the scale automatically and leave a gap between a helper line’s endpoint and the edge of the plot. If you later change the axis bounds, update the helper endpoints too. You can put the endpoint values in worksheet cells and edit those cells when the displayed range changes, which is easier to maintain than repeatedly rebuilding the series.

Format and label the chart for interpretation

Use a concise chart title that states what is being compared. Add axis titles and, where needed, explain the cutoffs in a subtitle or a small text box. A reader should be able to tell what each direction means and why the boundaries fall where they do. If the thresholds are averages, say so; if they are business targets, name them as targets.

Make the dividing lines visible without overpowering the points. A thin, neutral line or a dashed line often separates regions clearly while keeping attention on the observations. Use contrasting marker colors only when they encode an additional category. If the quadrants have labels such as High X / High Y, add text boxes with careful placement or use a legend and a short explanation. Do not rely on color alone to convey meaning.

For a chart with many observations, labels on every point can make it unreadable. Label only notable items, or use data labels from cells where that option is available in the desktop version. You can also retain names in the source table and identify points through their approximate coordinates. If labels overlap, reduce their number, make the chart larger, or adjust the axis scales rather than shrinking the text until it is difficult to read.

Common problems and how to fix them

  • The chart looks like categories rather than values: Confirm that you inserted an XY scatter chart, not a line chart. Check that the X values are numeric and are assigned to Series X values.
  • The line is diagonal or misplaced: A vertical helper series needs the same X value at both endpoints and different Y values. A horizontal series needs different X values and the same Y value at both endpoints.
  • A threshold line stops short: Match its endpoint values to the visible axis minimum and maximum, then confirm that the axes use those bounds.
  • The axes cross at zero instead of the cutoff: Reopen Format Axis and check the crossing setting on the opposite axis. For full-length lines that do not reposition axis labels, use helper series.
  • Points appear in the wrong quadrants: Verify the X/Y ranges and the threshold values, including their units. Also check whether larger values should mean better or worse performance; the chart does not assign a positive meaning to any direction.
  • Some observations are missing: Check for blank cells, text stored in numeric columns, filtered rows, and mismatched series ranges. A scatter plot cannot place a text value as a numeric coordinate.

A common misconception is that a four-quadrant chart must use the data’s midpoint or average. It does not. A center line is only appropriate when that cutoff is meaningful for the analysis. A target-based threshold can place most points in one region and still be useful if it represents a real decision boundary.

Excel for Mac and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. Excel for Mac also supports XY scatter charts, axis formatting, and additional series, but ribbon placement and the Format Axis pane can differ by release. Look for the chart design, select-data, and format-axis controls after selecting the chart. The underlying approach—numeric X/Y data and threshold series—remains the same.

Excel for the web can create and edit many chart types, but some advanced chart-formatting controls may be limited or arranged differently. If you cannot find a setting for axis bounds, crossing values, or series formatting, open the workbook in the desktop Excel app to finish the chart. When sharing the workbook, check the chart after editing it in another version because axis bounds and labels affect how the quadrants read.

Frequently Asked Questions

Can I make a four-quadrant chart without formulas?

Yes. You can enter the threshold values and helper-series endpoints directly into cells, then add those ranges as chart series. Formulas are optional; they are useful only if you want thresholds or endpoints to update automatically when the underlying data changes.

Should I use the mean or median for the dividing lines?

Use the measure that suits the question. The mean reflects the arithmetic average and can shift with extreme values; the median marks the middle observation and is more resistant to outliers. For a target or policy cutoff, use that value instead of treating an average as a rule.

Can I label each point with a name?

Yes. In desktop Excel, select the data series, add data labels, and use the data-label formatting options to display values from cells when available. Choose the cells containing names, then hide unwanted X or Y values. For a dense chart, label only selected points to avoid collisions.

Why do my points all appear in one quadrant?

They may genuinely all fall on the same side of one or both thresholds. Check that the cutoffs are in the same units as the plotted data and lie within the axis bounds. If the goal is to divide observations into balanced groups, a median-based cutoff may be more appropriate than a fixed target.

Can I add colored backgrounds to the four quadrants?

Excel does not turn a scatter chart into four colored regions automatically. You can use semi-transparent shapes placed over the plot area, but they may need repositioning when the chart is resized or its axes change. Separate helper series for the dividing lines are usually easier to maintain and less likely to obscure points.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.