How to Make a 4 Quadrant Graph in Excel

A spreadsheet full of numbers can feel like a guessing game. Is your data telling a story of success, pointing out a problem, or revealing a hidden opportunity? A four-quadrant graph, sometimes called a matrix chart, is one of the best ways to get clear answers by plotting your data based on two different variables. This tutorial will walk you through exactly how to build one in Excel, step-by-step, turning your raw numbers into a powerful visual for making smarter decisions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a 4 Quadrant Graph?

At its core, a 4 quadrant graph is just a scatter plot that has been divided into four equal sections. This simple division is surprisingly powerful. It takes a cloud of data points and organizes them into distinct categories based on where they land on the X (horizontal) and Y (vertical) axes.

Each axis represents a spectrum of value for a specific metric, like low-to-high cost or easy-to-difficult. By plotting data against two of these spectrums, you can quickly group items and prioritize action. It's a fundamental tool for strategic planning used in countless business contexts, including:

• The Eisenhower Matrix: A famous productivity tool that categorizes tasks based on Urgency vs. Importance to decide what to do, schedule, delegate, or delete.
• SWOT Analysis: Visualizing a company's Strengths and Weaknesses against external Opportunities and Threats.
• BCG Matrix: A portfolio analysis tool that plots products based on Market Share vs. Market Growth Rate to identify "Stars," "Cash Cows," "Question Marks," and "Dogs."
• Performance vs. Potential: A management tool to evaluate employee performance by plotting their current Performance score against their future Potential.

The goal is always the same: to move from a flat list of items to a strategic map that shows you where to focus your attention.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Preparing Your Data for a Quadrant Chart

Before you can build the graph, you need to structure your data correctly in your Excel sheet. A clean setup here will make the entire process smoother. You'll need at least three columns:

1. Item/Label: The name of what you are measuring (e.g., Task Name, Product Name, Employee Name).
2. X-Axis Value: The numeric value for the horizontal axis metric.
3. Y-Axis Value: The numeric value for the vertical axis metric.

Let's use a project task list as an example. We want to categorize our tasks using the Eisenhower Matrix method, so we’ll rank each task on a scale of 1 to 10 for both Importance (Y-axis) and Urgency (X-axis).

Here’s how our data would look in Excel:

A few tips for preparing your data:

• Be Consistent: Make sure you use the same scale for all your data points. If you're using a 1-10 scale, stick to it for every item.
• Find Your Center: You need to decide where the lines separating your quadrants will go. If your scale is 1-10, the logical center is 5. For other datasets, you might use the average or median value as the dividing line. Note this "center point" value for both your X and Y axes, you'll need it later.
• Keep It Simple: Avoid merged cells or complex formatting in your source data table. A straightforward table is all you need.

How to Make a 4 Quadrant Graph in Excel: Step-by-Step

With your data prepped, you're ready to create the visualization. Just follow these steps.

Step 1: Insert a Scatter Chart

First, we need to create a basic chart that plots our data points based on their X and Y values. The scatter chart is perfect for this.

1. Highlight only the numeric columns for your X and Y axes. In our example, that's the "Urgency" and "Importance" data.
2. Go to the Insert tab on the Ribbon.
3. In the Charts section, click on the icon for "Insert Scatter (X, Y) or Bubble Chart."
4. Select the first option, simply called Scatter.

You’ll now have a basic scatter plot with all your data points displayed as dots. It’s a start, but it doesn't have any quadrants yet.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Add and Format the Quadrant Axis Lines

Now for the most important step: defining the dividing lines that create the four quadrants. We'll do this by adjusting the axis settings to make them cross at our chosen center point.

For our 1-10 scale example, our center point is 5 for both axes.

Format the Horizontal (X) Axis:

1. Right-click on the vertical axis (the Y-axis line with the numbers) and select Format Axis... from the dropdown menu.
2. The Format Axis pane will appear on the right side of the screen. Look for the Axis Options section.
3. Under "Horizontal axis crosses," select Axis value and enter your Y-axis center point. For our example, this is 5. This moves the horizontal line up to the midpoint of the chart.

Format the Vertical (Y) Axis:

1. Now, right-click on the horizontal axis (the X-axis) and select Format Axis....
2. In the Format Axis pane, under Axis Options, find the "Vertical axis crosses" option.
3. Select Axis value and type in your X-axis center point. For our example, this is also 5.

Your chart should now clearly show four quadrants! But we still need to make it more readable and professional.

Step 3: Label Your Data Points

A bunch of anonymous dots isn't very helpful. Let’s add labels so you know which task is which.

1. Click on one of the data points in your chart to select the entire data series (all the dots should be highlighted).
2. Right-click and select Add Data Labels. Numbers will likely appear next to each dot.
3. Right-click the new data labels themselves and select Format Data Labels....
4. In the Format Data Labels pane, check the box for Value From Cells.
5. A small dialog box will pop up. Select the range of cells containing the names of your items (in our case, the "Task" column). Make sure you don't include the header. Click OK.
6. Finally, uncheck the "Y Value" box, leaving only "Value From Cells" checked. This replaces the default numeric labels with your task names.

Step 4: Title Your Quadrants

Excel doesn’t have a built-in function to title the quadrants, so we’ll add them manually using text boxes. This gives us full control over placement and formatting.

1. Go to the Insert tab and click on Text Box.
2. Click and drag to draw a text box in one of the quadrants (let's start with the top right).
3. Type in the appropriate label. For our Eisenhower Matrix, the top-right quadrant (High Urgency, High Importance) is "Do First."
4. Style the text box to make it blend in. With the text box selected, go to the Shape Format tab. Set the Shape Fill to "No Fill" and the Shape Outline to "No Outline."
5. Repeat this process for the other three quadrants:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 5: Final Formatting Touches

A few quick adjustments will take your graph from functional to professional and ready for a presentation.

• Add a Main Title: Click on "Chart Title" at the top and give it a descriptive name, like "Project Task Prioritization Matrix."
• Add Axis Titles: With the chart selected, click the "+" icon to the top right and check Axis Titles. Label the X-axis "Urgency" and the Y-axis "Importance."
• Clean Up Gridlines: The minor gridlines can make the chart look busy. You can remove them by either selecting and deleting them or unchecking Gridlines in the chart elements menu ("+" icon).
• Adjust Colors: Use color to add another layer of meaning. You could make the points in the "Do First" quadrant red and the "Delete" quadrant gray to visually reinforce the priority levels.

Your finished 4 quadrant graph is complete and ready to help you make strategic decisions!

Final Thoughts

Creating a four-quadrant graph transforms a simple Excel spreadsheet into a strategic visual that communicates complex relationships at a glance. By organizing your data against two significant metrics, you can quickly spot trends, identify outliers, and define clear priorities for your business, projects, or products.

While mastering charts in Excel is a great skill to have, pulling the data and building these reports can become a repetitive manual process, especially when your data lives across a dozen different apps. At Graphed, we automate the boring stuff. We connect directly to your data sources like Google Analytics, Shopify, or Salesforce, and you can just ask in plain language for what you need: "Create a 4-quadrant graph of my campaigns by cost vs. ROI for last month." In seconds, we build a live, updating dashboard that does the work for you, letting you focus on making decisions, not building charts.