How Do You Make a 4-Quadrant Graph in Excel? (2026 Guide)

A four-quadrant graph is the chart behind almost every prioritisation framework you have seen: effort versus impact, reach versus difficulty, growth versus market share. The idea is simple, and Excel has no button for it. There is no "quadrant chart" in the insert menu, which is why most people end up drawing the dividing lines by hand and then watching them drift the moment the data changes.

The reliable method is a scatter plot with its axes moved so they cross at the middle of your data rather than at zero. Done that way, the four zones are created by the axes themselves, so they stay correct when your numbers update.

How Do You Make a 4-Quadrant Graph in Excel?

Create a scatter plot from two numeric columns, then set each axis to cross at the midpoint of the other axis's range instead of at zero. The crossed axes divide the plot area into four quadrants automatically.

That is the whole trick. Everything else is presentation: labelling the zones, sizing the axis bounds so the split sits where you want it, and formatting the points so readers can tell which item is which.

The reason this beats drawing lines with shapes is that the axes are bound to the chart. Resize the chart, change the data, or print it, and the dividing lines move with everything else. Hand-drawn shapes do not, and a quadrant chart with misaligned dividers is worse than no chart at all.

You need exactly two numeric columns for the X and Y values, plus a third text column of labels if you want to identify individual points. Excel will not use the text column for plotting, only for labelling, which is a step people frequently miss.

Prioritising an SEO roadmap and want a second opinion on what to work on first? Get a free SEO Stuff audit and we will map the opportunities for you.

What the Four Quadrants Actually Represent

A quadrant chart is a scatter plot with meaning attached to regions rather than to exact positions. That framing drives every design decision that follows.

The Standard Quadrant Numbering

In mathematics the quadrants are numbered anticlockwise from the top right: quadrant one is top right, two is top left, three is bottom left, four is bottom right. Business charts rarely use those numbers, but knowing them helps when reading documentation or academic sources.

In practice most teams relabel them with plain language. Top right becomes "do first" or "stars", bottom left becomes "deprioritise", and the two off-diagonal zones get whatever names fit the framework.

Why the Axis Crossing Point Matters So Much

The position of the crossing point is a judgement call, and it changes the story the chart tells. Cross at zero and every positive value lands in the top right, which tells you nothing.

Cross at the median of each axis and you get a roughly even split, which is useful for relative comparison. Cross at a target threshold, such as a minimum acceptable conversion rate, and the quadrants become pass-fail zones instead. Choose deliberately and say which you used.

Position Versus Region

In a normal scatter plot the exact coordinates matter. In a quadrant chart the region matters more, and readers will treat anything near a dividing line as genuinely ambiguous.

That is a feature, not a flaw. If two items sit on either side of a line by a hair, they are not meaningfully different, and the chart is correctly refusing to pretend otherwise.

Step-by-Step: Building the Chart

Assume your data sits in three columns: labels in column A, the X metric in B, and the Y metric in C.

1. Select the two numeric columns, B and C, without the label column.
2. Go to Insert, then Charts, then Scatter, and pick the plain scatter with markers only.
3. Work out your crossing values. For a median split, use =MEDIAN(B:B) and =MEDIAN(C:C) in two spare cells.
4. Right-click the horizontal axis and choose Format Axis.
5. Under Axis Options, set Bounds Minimum and Maximum manually so your data sits comfortably inside the frame with a little margin.
6. Scroll to "Vertical axis crosses", select "Axis value", and enter your X crossing number.
7. Right-click the vertical axis and repeat: set bounds, then under "Horizontal axis crosses" enter your Y crossing number.
8. The plot area is now divided into four zones by the axes themselves.
9. Move the axis labels out of the way. In Format Axis, set Labels, then Label Position to "Low" so the tick labels sit at the chart edge instead of across the middle.
10. Add your item labels. Click the chart, choose Chart Elements, then Data Labels, then More Options, and tick "Value From Cells", selecting column A.
11. Untick X Value and Y Value so only the names show.
12. Format the markers larger and apply a lighter grid or no gridlines at all, so the quadrant structure reads clearly.

Step nine is the one most tutorials skip, and it is the difference between a clean chart and one where the axis numbers run straight through the middle of your data.

How to Label the Quadrants

Named zones make a quadrant chart self-explanatory. There are two reasonable ways to add them.

The simplest is a text box per quadrant. Insert, Text Box, then type the zone name and drag it into the corner. Group the text boxes with the chart so they move together.

The more robust option is a second data series holding four invisible points, one placed in each quadrant corner, with data labels pulled from cells using "Value From Cells". Set the marker fill to none so only the text shows. This survives resizing, because the labels are anchored to coordinates rather than floating on top.

Whichever you choose, keep zone names short. Two or three words each is plenty, and long names compete with the data points for attention.

Sitting on a backlog of content ideas with no clear order? Get a free SEO Stuff audit and we will help you sequence the work.

When a Quadrant Chart Is the Right Choice

Quadrant charts earn their place in a narrow set of situations, and they get overused well outside it.

Use one when you have two metrics that genuinely trade off against each other and a set of items to compare on both at once. Effort against impact is the classic. Search volume against keyword difficulty is the same shape.

Use one when the decision you want from the reader is categorical rather than numeric. Quadrants answer "which bucket does this belong in", not "how much larger is A than B".

Use one when the item count sits roughly between eight and forty. Fewer than eight and a simple table communicates faster. More than forty and the labels overlap into an unreadable mess.

Avoid one when a single ranked metric would do. If you can sort the list and act on the top ten, a sorted bar chart is clearer and takes a fraction of the time to build.

Comparing keyword opportunities on volume and difficulty and want the shortlist checked? Get a free SEO Stuff audit and we will pressure-test it.

Limitations and Common Problems

Overlapping Labels

The most common complaint. Excel does not offset labels intelligently, so clustered points produce stacked text.

Mitigate it by shortening names, setting label positions individually for the worst offenders, or splitting the chart into two by category. There is no automatic fix inside Excel.

The Crossing Point Can Mislead

Because the split location is chosen rather than given, a quadrant chart can be quietly manipulated. Shifting the median by a few percent moves items between zones and changes the recommendation.

Always state the crossing rule directly on the chart, such as "axes cross at median". It takes one text box and makes the chart honest.

Scale Distortion

If your two metrics have wildly different ranges, one axis compresses and the visual spread misleads. Consider normalising both metrics to a common scale, such as a percentile or a one-to-ten score, before plotting.

No Third Dimension

A plain scatter plot shows two variables. If you need a third, such as revenue size per item, switch the chart to a bubble chart and drive bubble size from that third column. The quadrant setup is otherwise identical.

Quadrant Chart vs the Alternatives

Quadrant Chart vs Bubble Chart

They are close relatives. A bubble chart is a scatter plot with a size dimension, and you can apply exactly the same crossed-axis technique to it. Use bubbles when a third metric matters and the extra visual weight will not overwhelm the layout.

Quadrant Chart vs Sorted Bar Chart

A bar chart ranks on one metric and is faster to read. A quadrant chart shows the trade-off between two. If nobody in the room is arguing about the trade-off, use the bar chart.

Quadrant Chart vs Heatmap Table

A conditionally formatted table handles many items and many metrics far better than a scatter plot can. It loses the intuitive spatial grouping, but it scales past the forty-item ceiling comfortably.

Excel vs Purpose-Built Tools

Dedicated visualisation tools have quadrant templates with automatic label collision handling, which Excel lacks. For a one-off chart in a deck Excel is fine. For a matrix you rebuild monthly with shifting data, the manual label work adds up.

Final Thoughts

A four-quadrant graph in Excel is a scatter plot with its axes moved to cross at a meaningful midpoint, and almost everything that makes one look professional happens after the chart is inserted: choosing the crossing rule, pushing the axis labels to the edges, and pulling point names from cells rather than typing them. Decide your crossing rule before you build, write it on the chart, and keep the item count low enough that the labels stay readable. If a third metric turns out to matter as much as the first two, our explainer on what a bubble chart is in Excel covers the natural next step.

Ready to turn a prioritised list into actual organic growth? Get a free SEO Stuff audit and we will build the plan with you.