Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Make a Quadrant Chart in Google Sheets

Cody Schneider••8 min read

A quadrant chart is one of the most effective ways to visualize the relationship between two different metrics and make strategic decisions quickly. By plotting your data points across two axes, you can instantly see which items are high-performers, which are underachievers, and where the best opportunities lie. This guide will walk you through exactly how to set up your data and build a clear, insightful quadrant chart directly in Google Sheets.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

What Exactly is a Quadrant Chart?

A quadrant chart, also known as a 2x2 matrix, is a scatter plot divided into four equal sections. Each section, or "quadrant," represents a different combination of performance based on the two variables you're measuring on the horizontal (X-axis) and vertical (Y-axis). This simple visual framework is incredibly versatile and helps you move beyond raw data to strategic insights. It’s perfect for answering questions like:

  • Effort vs. Impact: Which tasks took the most time versus which ones delivered the biggest results? (An Eisenhower Matrix is a classic example of this.)
  • Cost vs. Return: Which marketing campaigns are burning money with little return, and which are highly efficient?
  • Urgency vs. Importance: Which product features should the engineering team work on next?
  • Performance vs. Potential: Which sales reps are star performers, and which ones need more coaching?

By plotting your data in this way, you can easily categorize items and prioritize your actions, making it a favorite tool for managers, marketers, and anyone trying to make sense of complex information.

Step 1: Structure Your Data Correctly

Before you can build the chart, your data needs to be organized in a specific way. Google Sheets needs three columns to create a proper scatter plot, which is the foundation of our quadrant chart. Here’s the simple structure you need:

  • Column A - Label: This column contains the name of each item you want to plot. It could be a campaign name, a sales rep’s name, a task, or a product feature. This label will identify each point on your chart.
  • Column B - X-Axis Value: This is your first metric. It's the value that will be plotted along the horizontal axis. Examples include Cost, Effort, or Importance Score.
  • Column C - Y-Axis Value: This is your second metric. It’s the value that will be plotted along the vertical axis, such as Revenue, Impact, or Urgency Score.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Example Data Setup for Marketing Campaigns

Let's imagine you're a marketing manager analyzing the performance of recent campaigns. You want to compare the Ad Spend (Effort) against the number of Sales (Impact). Your Google Sheet might look like this:

This clean, three-column layout is the perfect foundation for our chart.

Step 2: Create the Base Scatter Plot

With your data structured correctly, creating the initial scatter plot takes just a few clicks.

  1. Select Your Data: Click and drag to highlight all the data in your three columns, including the headers. In our example, you'd select cells A1 through C9.
  2. Insert the Chart: Go to the menu bar at the top and click Insert > Chart.
  3. Choose Chart Type: Google Sheets will likely try to guess the chart you want, and it might not be correct. In the "Chart editor" pane that appears on the right, under the Setup tab, find "Chart type." Click the dropdown and scroll down to the "Scatter" section. Select Scatter chart.

Instantly, you should see a chart with your data points plotted. Each point represents one of your campaigns, positioned based on its Ad Spend and Sales. But right now, it's just a scatter plot — it's missing the lines that define the four quadrants.

Step 3: Add the Quadrant Dividing Lines

This is the part that isn't immediately obvious in Google Sheets. You have to manually add horizontal and vertical lines to divide the chart into four sections. The key is to decide where to place these lines. They should represent the average or a meaningful midpoint for your data.

You have two primary ways to determine your midpoints:

Method 1: Using Averages (Most Common and Dynamic)

Using the average value for your X and Y axes creates a mathematically balanced chart. This is the best approach when you want to see which items are above or below the average performance for the group.

  1. Calculate the Average for your X-Axis: Find a blank cell below your data and use the =AVERAGE() formula. For our example, in cell B11, you would type:
  2. Calculate the Average for your Y-Axis: In another blank cell (e.g., C11), do the same for your second metric:

Now you have the two values you need to create your dividing lines: 1,837 for the vertical line and 113 for the horizontal line.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Method 2: Using a Manual Threshold

Sometimes, a statistical average isn’t the best dividing line. You might have a specific business goal or threshold you want to measure against. For instance, you might decide that any campaign costing over $2,000 is "High Cost" and any campaign generating over 100 sales is "High Impact." In that case, your midpoints are pre-defined by your strategy.

Adding the Lines to Your Chart

With your midpoint values decided, it's time to add them to the scatter plot:

  1. Open the Customization Panel: Double-click on your chart to re-open the "Chart editor." Click on the Customize tab.
  2. Add the Vertical Line:
  3. Add the Horizontal Line:

With those two lines in place, your scatter plot has been transformed into a full-fledged quadrant chart!

Step 4: Customize and Interpret Your Chart

A functional chart is good, but a well-labeled and easy-to-read chart is great. Here are a few final touches to make your quadrant chart truly useful.

Essential Customizations

  • Add Informative Titles: Under Customize > Chart & axis titles, give your chart a descriptive title, like "Marketing Campaign Performance: Ad Spend vs. Sales". Label your horizontal and vertical axes clearly (e.g., "Ad Spend ($)" and "Number of Sales"). This removes any guesswork for your audience.
  • Show Data Labels: It's helpful to see which dot represents which campaign. Go to Customize > Series. Scroll down and check the box for Data labels. By default, it will show the Y-value, but you can change it to show the label from Column A by selecting 'Left' or 'Right' under the Position dropdown and then specify data label to A2:A9 as "value". This step can be tricky with sheet's functionality, sometimes it's easier just to present the chart and speak to the outlier points.

How to Interpret the Four Quadrants

This is where your work pays off. By naming each quadrant, you create a powerful strategic framework. Using our marketing example:

Top Right Quadrant (High Spend, High Sales): Scale Up Campaigns here are expensive but effective. These are your star performers. The "Holiday Promo" sits here. The action is clear: Invest more into these proven winners.

Top Left Quadrant (Low Spend, High Sales): Efficiency Champions These are your hidden gems! They deliver great results without a big budget. The "Influencer Collab" and "Back-to-School" campaigns are in this sweet spot. The action: Analyze what makes them so efficient and replicate it.

Bottom Left Quadrant (Low Spend, Low Sales): Test or Eliminate These anemic campaigns don't cost much, but they also don’t deliver much. "Video Ad Test" and "Local SEO" live here. The action: Can they be optimized with a few small tweaks, or is it better to cut them and re-allocate the small budget elsewhere?

Bottom Right Quadrant (High Spend, Low Sales): The Money Pits Warning! These campaigns are burning a hole in your budget with very little to show for it. The "Rebranding Launch" falls here. The action: Investigate what went wrong immediately. Unless there’s a quick and obvious fix, pause or cut these campaigns now.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Final Thoughts

Creating a quadrant chart in Google Sheets is a fantastic way to turn a simple spreadsheet into a strategic decision-making tool. By preparing your data, using a scatter plot, and manually adding average gridlines, you can build a visualization that quickly highlights opportunities and risks without needing complex software.

Of course, building these reports in a spreadsheet is still a manual process. You have to gather the data, clean it, build the report, and then repeat it all next week or next month. At Graphed, we created an alternative so you can skip these manual steps. Instead of pulling data and wrestling with menus in Google Sheets, we connect directly to your marketing and sales platforms (like Google Analytics, Shopify, Facebook Ads, Salesforce, etc.) allowing you to create a live-updating dashboard simply by describing what you want in plain English. Just asking, "Show me a quadrant chart of all my campaign spend vs. return on spend for the last 30 days," and receiving an instant visualization gives you back time to focus on strategy, not spreadsheet formulas.

Related Articles