Quadrant Chart in Google Sheets: How to Build One

Google Sheets does not have a dedicated quadrant-chart type, but you can make one with a scatter chart and helper columns that split your points into four color-coded groups. Add cutoff values for the two axes, then use the chart’s horizontal and vertical gridlines—or carefully placed drawing lines—to make the quadrants easier to read.

What a quadrant chart shows

A quadrant chart is a scatter plot divided into four regions by a vertical and a horizontal threshold. Each point represents an item with two measured values. The thresholds classify the item according to whether each value is above or below its chosen cutoff.

For example, a product team might plot customer satisfaction on the horizontal axis and monthly sales on the vertical axis. A product above both cutoffs falls in the high-satisfaction, high-sales region; one below both falls in the low-low region. The other two regions reveal mixed results that may deserve different follow-up.

“Quadrant chart” describes the way the scatter plot is interpreted, not a separate chart type built into Google Sheets. The distinction matters: the scatter plot positions the values, while helper columns and formatting make the four groups visible. The thresholds are choices made for your analysis, not automatic judgments made by Sheets.

Choose meaningful axes and thresholds

Before charting, decide what one dot represents and what each axis measures. Each item needs a numeric X value and a numeric Y value. Use consistent units and a clear direction: if a higher value means worse performance on one measure, note that in the axis title rather than assuming readers will know.

Then choose a cutoff for each measure. A cutoff might be a target, a benchmark, a median, or a practical decision boundary. A score of 50 is convenient for an illustration, but it is not a universal midpoint or a statistically meaningful threshold. If the values are percentages, for instance, 50 may be a sensible boundary in one analysis and irrelevant in another.

Use a target when the chart should show progress against a goal.
Use a median or another stated statistic when you want to compare items relative to the group.
Use a decision boundary when the regions will guide a specific action.

Write down the cutoff values and the rule for items exactly on a cutoff. In the example below, values equal to a cutoff count as high because the formulas use greater-than-or-equal comparisons.

Set up the source data

Keep the original records in one table and make a separate helper table for charting. This keeps the source values intact and makes it easier to inspect whether a dot was assigned to the intended region.

For the example, put item names in A2:A11, X values in B2:B11, and Y values in C2:C11. Enter the X cutoff in H1 and the Y cutoff in H2. Put X in J1 and four series headings in K1:N1: High X, high Y; High X, low Y; Low X, high Y; and Low X, low Y. The separate chart table will repeat each X value while placing the Y value in only the series that applies.

With item names in A2:A11, X values in B2:B11, and the X cutoff in H1, enter this in J2 and fill it down alongside the source records:

=B2

With X values in B2:B11, Y values in C2:C11, and cutoffs in H1 and H2, enter this in K2 for the high-X, high-Y series, then fill down:

=IF(AND($B2>=$H$1,$C2>=$H$2),$C2,"")

With the same source columns and cutoff cells, enter this in L2 for the high-X, low-Y series, then fill down:

=IF(AND($B2>=$H$1,$C2<$H$2),$C2,"")

With the same source columns and cutoff cells, enter this in M2 for the low-X, high-Y series, then fill down:

=IF(AND($B2<$H$1,$C2>=$H$2),$C2,"")

With the same source columns and cutoff cells, enter this in N2 for the low-X, low-Y series, then fill down:

=IF(AND($B2<$H$1,$C2<$H$2),$C2,"")

Each formula returns the Y value only when the row meets that series’ two conditions; otherwise it returns an empty string. This gives the chart four separately editable series, so you can assign a different point color to each group. Keep the headers in row 1 and include the entire filled chart table when selecting its data range.

Build the scatter chart

Select the helper table, including its headers, such as J1:N11.
Choose Insert > Chart. In the Chart editor’s Setup tab, open the Chart type menu and select Scatter chart.
Check that column J is being used for the X-axis and columns K through N appear as the four data series. If the preview does not show the expected groups, check the selected range and the first row’s headers.
Use the Customize tab to give the chart a descriptive title and set horizontal and vertical axis titles. Under Customize > Series, select each series and choose a distinct point color.
Under the axis settings, set minimum and maximum values if needed so the plot uses a useful, consistent scale. Keep the cutoffs within the visible range.

For example, set H1 and H2 to 50. An item with X = 80 and Y = 70 appears in High X, high Y. An item with X = 30 and Y = 65 appears in Low X, high Y. An item at exactly X = 50 is treated as high X under these formulas. If the chart is intended to compare several periods, keep the axis limits the same across charts; otherwise, a change in scale can make similar values look substantially different.

Show the quadrant boundaries

The four colors tell readers which group each point belongs to, but they do not necessarily draw a divider exactly at your two cutoff values. Google Sheets’ scatter chart does not provide a simple dedicated control for inserting arbitrary vertical and horizontal reference lines at specified numeric values. Its gridlines can help, but they may not land precisely on your chosen thresholds.

First try to make the cutoffs legible through axis titles, series colors, and a note in the chart title or a nearby cell. If a cutoff coincides with a visible gridline, that line may serve as a useful visual boundary. Check the actual axis scale rather than assuming a gridline marks the threshold.

For a fixed report, you can use Insert > Drawing to create horizontal and vertical lines and position them over the chart. This is a visual workaround, not a data-linked chart feature: the lines will not automatically move when the cutoffs or chart dimensions change. Recheck their positions after editing or resizing the chart, and do not rely on them for precise reading unless you verify their alignment.

If the divider must be exact, a more maintainable option is to use a tool or charting workflow that supports numeric reference lines directly. Another possibility is to build a custom visualization outside the standard Sheets scatter chart. Choose that extra complexity only when exact divider placement is important; for many summaries, four colored groups and clearly stated cutoffs communicate the classification adequately.

Improve labels and interpretation

Use axis titles that include units, such as “Satisfaction score (0–100)” and “Sales per month ($).” State the cutoff values in the chart subtitle or in text beside the chart. A viewer should not need to guess whether “high” means above a target, above an average, or simply above an arbitrary split.

Scatter charts can become crowded when many items have similar coordinates. Increase the chart’s size, choose point colors with strong contrast, and avoid using four nearly identical shades. If labels overlap, label only the important points in a separate table or call out a few items in nearby text rather than trying to label every dot.

Also consider whether the axes should begin at zero. A zero baseline can be appropriate for some measures, while a narrow range can reveal small differences; either choice changes the visual impression. Set bounds deliberately, disclose unusual scales, and keep bounds consistent when readers are comparing multiple charts.

Common problems and fixes

All points have the same color: The chart may contain the original X and Y columns instead of the four helper series. Confirm that the selected range includes J:N and that each helper column has its own heading.
Points appear in the wrong group: Check the cutoff cells and comparison signs in the formulas. This example assigns equality to the high group; using a strict greater-than sign would change that boundary rule.
A series is empty: Confirm that the source values are numbers, the cutoff cells contain numeric values, and the formulas were filled through the data rows. Text that looks like a number may not compare as expected.
The chart scale hides points: Review the horizontal and vertical axis minimum and maximum settings. An item outside a manually limited range will not be visible in the plot area.
The divider line no longer matches: A drawing placed over the chart is independent of the data. Reposition it after a resize or change in axis bounds, or remove it and communicate the threshold another way.

When another chart may work better

A quadrant chart is useful when the two measures together support a meaningful classification. It is less useful when the thresholds are arbitrary, when the points overlap heavily, or when readers need to compare exact values more than broad groups. A plain scatter chart may be clearer if the relationship between the measures is the main question and quadrant labels would distract from it.

If there is only one measure, a sorted bar chart may make comparisons easier. If items also have a meaningful third numeric measure, a bubble chart can encode that as bubble size, though it can be harder to read accurately. A table with conditional formatting may be preferable when exact values and category membership matter more than spatial patterns. These alternatives are available as charting or formatting approaches in Sheets; they do not make the quadrant chart itself a native chart type.

Frequently Asked Questions

Does Google Sheets have a quadrant chart template?
No dedicated quadrant-chart type is listed in the standard chart options. Use a scatter chart, split the points into helper series, and format those series to show the four groups.

Can I add a vertical and horizontal cutoff line automatically?
There is no simple built-in scatter-chart setting for arbitrary numeric reference lines at both chosen cutoffs. Gridlines may help if their positions align, while drawing lines are a manual overlay that must be checked after chart changes.

Can the quadrants use different colors?
Yes. Put each group’s Y values in a separate helper column and leave other rows blank in that series. Then use Customize > Series in the Chart editor to format each plotted series separately.

Should the cutoff be the average or the median?
Neither is automatically correct. Choose the threshold that fits the question: a goal, benchmark, median, or operational decision boundary can each be appropriate. State the method and values so readers understand what the quadrants mean.

Will the chart update when I change a cutoff?
The helper formulas recalculate when H1 or H2 changes, so the group assignments can update. However, a manually drawn divider line does not update with them, and axis bounds may need adjustment if new values fall outside the visible range.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.