Quadrant Scatter Plot in Excel: Create and Format One

How-to basics · Updated November 21, 2026

To create a quadrant scatter plot in Excel, insert an XY scatter chart, then add one vertical and one horizontal helper series at your chosen cutoff values. The two lines divide the chart into four regions, making it easier to compare observations by both their horizontal and vertical values.

What a quadrant scatter plot shows

A quadrant scatter plot is a standard scatter chart with a vertical reference line and a horizontal reference line. Those lines divide the plot into four areas. Each dot represents a record, and its position is determined by a numeric X value and a numeric Y value. The quadrants make combinations of the two measures easier to scan: high X and high Y, low X and high Y, and so on.

For example, a service team could plot response time on the X axis and customer satisfaction on the Y axis. If the cutoffs are 10 days and 80%, the upper-left region contains cases with faster responses and higher satisfaction, while the lower-right region contains slower responses and lower satisfaction. Whether a high value is desirable depends on the measure: a high satisfaction score may be positive, but a high error rate may not be.

The dividing lines are decision or comparison thresholds, not a special chart type in Excel. Choosing meaningful cutoffs is therefore as important as drawing the lines. A median can split a dataset into broadly balanced groups, while a business target can show which records are above or below a goal.

Prepare the data for an XY scatter chart

Arrange the data in columns with one numeric variable for X and one numeric variable for Y. Add a row of headings, and keep each observation on the same row so the two values stay paired. For instance, columns A and B might contain Response days and Satisfaction score, with one case per row. An optional third column can hold a name or ID for identifying points later.

  • Use actual numbers for both plotted measures. Values that look numeric but are stored as text can be omitted or plotted incorrectly.
  • Check for blank cells, errors, and accidental totals in the data range. A total row usually should not be treated as an observation.
  • Keep units consistent. Do not mix percentages entered as 80 with percentages entered as 0.8 unless that difference is intentional.
  • Decide what the cutoff lines mean before building the chart: a target, a fixed benchmark, or a statistic such as the median.

Unlike a line chart, an XY scatter chart uses numeric X values to position points along a value axis. This matters when the X values are dates, measurements, or unevenly spaced quantities. A category chart may space labels evenly and therefore misrepresent those numeric distances.

Create the base scatter chart

  1. Select the two numeric columns, including their headings. If the columns are separated by other data, select the X range and then the Y range as appropriate for your Excel setup, or create the chart first and edit its series afterward.
  2. On the Windows ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select Scatter with only Markers. This creates dots without connecting lines.
  3. Check that Excel assigned the intended column to each axis. Select the chart, choose Chart Design > Select Data, select the plotted series, and choose Edit to review its Series X values and Series Y values ranges.
  4. Add axis titles using Chart Design > Add Chart Element > Axis Titles, then choose the horizontal and vertical title options. Name each axis with both the measure and its unit where useful.

On Mac, the scatter-chart option is also on the Insert tab, though ribbon spacing and menu presentation can vary by Excel release. Excel for the web can create and edit many charts, but some detailed chart-formatting controls may be more limited than in the Windows desktop application. If a setting described below is not available in the web interface, open the workbook in desktop Excel.

Add the vertical and horizontal cutoff lines

The most controllable method is to add two helper series. Place a small helper table beside the source data. If your chosen vertical cutoff is 10 and your visible Y-axis range is 0 to 100, its two points are X = 10, Y = 0 and X = 10, Y = 100. For a horizontal cutoff of 80, its two points are X = the visible X-axis minimum and maximum, and Y = 80 for both points. These pairs form straight lines across the plot.

  1. Set or confirm the chart’s axis limits before entering the endpoints. Select an axis, open Format Axis, and enter suitable Minimum and Maximum bounds under Axis Options. Use bounds that include the observations and the intended cutoff.
  2. In the helper table, create two X values and two Y values for the vertical line, then two X values and two Y values for the horizontal line. Use the same cutoff value for both coordinates on the relevant axis.
  3. Select the chart and choose Chart Design > Select Data > Add. Give the first helper series a name such as X cutoff, then select its two X cells for Series X values and its two Y cells for Series Y values. Repeat for the Y cutoff series.
  4. With the chart selected, choose Chart Design > Change Chart Type. Set each helper series to an XY scatter type with straight lines. The original data series should remain Scatter with only Markers.
  5. Format each helper series: remove its markers, choose a clear line color, and adjust line width or dash style. Keep the dividing lines distinct from the dots without making them overpower the data.

Helper-series endpoints should match the chart’s displayed bounds. If the axis minimum or maximum changes later, update the corresponding endpoint cells too; otherwise, a line may stop short of the plot edge. The helper table can sit on the same worksheet or on another sheet in the workbook. Keeping it labeled makes the chart easier to maintain.

Choose useful cutoffs and label the quadrants

There is no universally correct way to choose a split. A fixed target is easy to explain—for example, a satisfaction target of 80%—and is useful when the chart is meant to show performance against a standard. A median or average can help compare records relative to the current dataset, but the resulting division may change when the data changes. A median is less affected by unusually large or small values than an average.

Be explicit about the interpretation. For a chart of sales growth and profit margin, the upper-right quadrant may represent strong results on both measures. For cost and quality defects, however, the upper-right quadrant may represent high cost and many defects, which is likely undesirable. Avoid labeling regions simply Good and Bad unless the direction and meaning of both measures support those labels.

To name the regions, add brief quadrant labels such as High growth / high margin. In desktop Excel, select the chart before inserting a text box so it is associated with the chart area, then position it in the relevant region. Text boxes are annotations rather than data-driven labels: moving the axes, changing the cutoffs, or resizing the plot may require repositioning them. A legend can identify the cutoff lines, but it does not explain the meaning of each region by itself.

Format the chart for clear reading

Use a descriptive chart title that states the measures or the question being analyzed. Keep the two axis titles visible, and retain units where readers might otherwise confuse a score, percentage, currency amount, or time interval. If the points overlap heavily, smaller markers or transparency can reveal clusters, while a restrained color scheme keeps attention on the data.

  • Use a contrasting but subdued style for the cutoff lines, such as a thin gray dashed line.
  • Choose axis limits that show the full data range without leaving a large, unexplained empty area.
  • Use consistent numeric formatting, such as percentage labels for percentages and a suitable number of decimal places for measurements.
  • Add data labels only when they help identify important records. Labels on every point can make a crowded chart unreadable.
  • Consider a legend or a small note that states the cutoff values and how they were selected.

Excel does not automatically shade the four quadrants as distinct regions when you add the lines. You can add translucent shapes or chart-area annotations for emphasis, but these are visual decorations and are not linked to the thresholds. They may need adjustment if the chart is resized or the axis bounds change. For a report that must stay accurate under frequent updates, the two reference lines and clearly explained labels are often more reliable than manually shaded blocks.

Common problems and how to fix them

If the chart shows a line of points instead of a spread, first check that the intended columns are assigned to the X and Y values and that both are numeric. If Excel treats one measure as text, convert or correct the source values and edit the series ranges. Also check that the chart is an XY scatter chart rather than a line chart.

If a cutoff line appears diagonal, its helper points probably do not share the same X value for a vertical line or the same Y value for a horizontal line. If it appears only as a dot, the helper series may still be set to markers only. If it reaches only partway across the chart, its endpoints may not match the visible axis minimum and maximum.

Axis crossings can also confuse readers. Excel may place an axis at zero, which can put it through the middle of the plot when values include negatives. The quadrant thresholds are not necessarily zero, so use the helper series to position the dividing lines at the chosen cutoffs rather than assuming the default axes are the quadrant boundaries. Keep the actual chart axes and the reference lines visually distinguishable.

How this differs from using axis crossings

One alternative is to change where the chart axes cross: format the horizontal value axis and set where the vertical axis crosses, then format the vertical value axis and set where the horizontal axis crosses. This can be quick for charts where the desired boundaries are zero and the axes themselves should appear at those positions.

However, moving the axes also moves their labels and may change the chart’s overall appearance. It can be awkward when the split values are not zero, when you want the axes to remain at the plot edges, or when you want the cutoff lines to have a separate style and legend entry. Helper series are more flexible because the split lines are independent chart series, while the axes continue to serve as scales.

Frequently Asked Questions

Can Excel make a quadrant chart automatically?
Excel has scatter charts, but it does not provide a dedicated automatic quadrant-chart command. Create an XY scatter chart and add vertical and horizontal reference series at the desired thresholds.

Can I use the average or median as a cutoff?
Yes. Calculate the chosen statistic from the relevant source data, then use that value as the helper series’ X or Y coordinate. State whether the split is based on an average, median, or external target so readers understand what the regions mean.

Do both cutoff lines have to cross at the center?
No. They meet at the pair of selected thresholds, which may be off-center. The lines should reflect the analysis rather than be moved just to make four equally sized regions.

Will the quadrant lines update when the data changes?
The lines update if their helper-cell values or formulas update, but manually entered endpoints and thresholds do not recalculate by themselves. If the chart’s axis bounds change, check that the line endpoints still reach the plot edges.

Can I add names to the dots?
Yes. You can add data labels and configure them to show values or, in supported desktop Excel versions, values from cells. For a busy chart, label only selected points or use a separate key so the labels do not overlap.

Can I create quadrant lines with negative values?
Yes. Scatter charts support negative numeric values. Set axis bounds that include the data and thresholds, then use helper-series endpoints that match those displayed bounds.

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.