To make a 4-quadrant graph in Excel, plot your paired X and Y values in an XY scatter chart, then add one vertical and one horizontal line at your chosen thresholds. The lines divide the chart into four sections so you can compare each point by two measures—for example, effort and impact. You’ll need a table of paired numeric values and a threshold for each axis; the steps below use a 0–100 scale and a threshold of 50.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows. The equivalent chart tools are available in Excel for Mac, although ribbon labels and dialog layouts can vary slightly.
- A label for each item and one numeric X value and Y value per item.
- An X-axis threshold and a Y-axis threshold. These can be the same, such as 50, or different values that suit your data.
Step-by-Step
- Arrange the data in columns. Put item names in column A, X values in column B, and Y values in column C. Use clear headings in row 1, such as Item, Impact, and Effort. Each item must have a number in both value columns. For a small example, enter Alpha, Beta, Gamma, Delta, Epsilon, and Zeta in A2:A7, with a value from 0 to 100 in both B and C for each row. Do not include blank rows within the data or combine multiple values in one cell. The X and Y values in the same row form one plotted point.
- Choose the thresholds and chart bounds. Decide where the dividing lines should fall. For this example, use 50 on both axes and set both chart scales from 0 to 100. A threshold is a decision boundary, not necessarily an average. For example, if an item with an impact score of 50 or more is considered high impact, place the vertical line at X = 50. You can use different thresholds, such as X = 60 and Y = 40, if the two measures have different meanings or ranges.
- Insert an XY scatter chart. Select the numeric range B1:C7, including its headings. Go to Insert > Insert Scatter (X, Y) or Bubble Chart and choose Scatter, the option with markers only. Excel should use the first numeric column as the horizontal values and the second as the vertical values. Check that it has not included the item names as numeric data; names are not required to create the scatter plot.
- Add two small helper tables for the dividing lines. In unused columns, enter a vertical-line table with headings Vertical X and Vertical Y, then put 50 and 0 in its first data row and 50 and 100 in its second. In another pair of columns, make a horizontal-line table with headings Horizontal X and Horizontal Y; enter 0 and 50 in the first data row and 100 and 50 in the second. These two endpoint pairs describe a vertical line from (50, 0) to (50, 100) and a horizontal line from (0, 50) to (100, 50). If you chose different thresholds or chart bounds, use those values instead.
- Add the vertical helper series. Click the chart, then select Chart Design > Select Data and choose Add. In the Edit Series dialog, set Series name to the vertical-line heading, Series X values to the two vertical X cells, and Series Y values to the two vertical Y cells. Use the range-selector button beside a field if you need to select cells directly on the sheet. Do not include the heading cells in the X or Y ranges. Confirm the dialog, then repeat the same process for the horizontal helper table.
- Use a chart type that can display the lines. Select Chart Design > Change Chart Type, choose XY (Scatter), and select Scatter with Straight Lines and Markers. This allows Excel to draw the two endpoint pairs as lines. Because that chart type can also connect the original data points, right-click the main data series and choose Format Data Series. In the formatting pane, open Fill & Line > Line and select No line for the main series. The data points will remain visible without being connected to each other.
- Format each helper series as a clean divider. Right-click the vertical helper series and choose Format Data Series. Under Marker > Marker Options, choose None; under Fill & Line > Line, choose a solid line. Repeat for the horizontal helper series. Give the two lines a contrasting color and a modest width so they are easy to see without overpowering the data. If you see only endpoint dots, check that the helper series has a solid line. If you see dots at the ends of the dividers, check that its marker option is set to None.
- Set both axes to the same bounds as the helper endpoints. Right-click the horizontal axis and choose Format Axis. Under Axis Options, set the minimum bound to 0 and maximum to 100. Do the same for the vertical axis. The helper lines now span the plot area and cross at (50, 50). If your data use another range, replace 0 and 100 with the minimum and maximum you want displayed, and make the helper endpoints match. Keeping the bounds fixed also stops Excel from changing the visible scale when values are edited.
- Add context and check the four sections. Select the chart and use Chart Design > Add Chart Element to add axis titles and a chart title. Name the axes with the measures they represent, not just X and Y. To label the sections, select the chart first, then use Insert > Text Box and place a short label in each quadrant, such as “High impact, low effort.” Keep labels away from points and gridlines. Confirm that points below and left of the thresholds are in the lower-left quadrant, and that points above and right are in the upper-right quadrant. Save the workbook when the chart is ready.
On Excel for Mac, use the same scatter-chart approach; the chart tabs and formatting pane may have slightly different names or positions. If a ribbon command is not visible, click the chart first so its chart-specific tabs appear. Excel for the web may also present chart formatting controls differently, so use the desktop app if you cannot find the series-level line and marker settings.
Common Mistakes
- Using a line chart instead of an XY scatter chart. A line chart treats the horizontal values as categories and may space points evenly, even when their X values differ. A scatter chart positions each point using its actual X and Y numbers.
- Selecting the wrong columns for a series. Each series needs its own X range and Y range. If the vertical line slopes or appears in the wrong place, check that its X range contains 50 twice and its Y range contains 0 and 100.
- Letting Excel auto-scale the axes. If an axis extends beyond the helper endpoints, the divider may stop short of the plot edge. Set minimum and maximum bounds explicitly and use matching helper endpoints.
- Leaving the main series connected. Scatter with Straight Lines and Markers connects points in sequence. Set the main data series to No line so the chart shows separate observations rather than an unintended zigzag.
- Assuming the midpoint is automatically the right threshold. A split at 50 only makes sense if that value is meaningful for your scoring system. Choose boundaries based on your definitions, and label them clearly.
Tips
- Use a consistent scale when the measures are comparable. For example, scores from 0 to 100 on both axes make the chart easier to scan. If measures use different units, keep their correct axis ranges rather than changing values just to make the chart look square.
- Use different thresholds when needed. The vertical helper series should repeat the chosen X threshold in both X cells; the horizontal helper series should repeat the chosen Y threshold in both Y cells.
- Give the original data series a distinct marker color and keep the divider lines thinner or lighter. This makes observations, rather than the grid, the focus.
- For a chart that will be updated, keep the source and helper tables together on the sheet and label them. When you add new observations, include them in the chart’s data range; the two-point helper series do not need extra rows.
- Consider adding the item names as data labels if readers need to identify individual points. In current Microsoft 365 desktop Excel, select the data series, use Chart Design > Add Chart Element > Data Labels, then use the label formatting options to show a cell range when that option is available. If labels overlap, label only the most important points or move labels individually.
- Use descriptive quadrant names that match your decision. A prioritization chart might use “Do first,” “Plan,” “Quick wins,” and “Deprioritize,” but explain what high and low mean before readers interpret those labels.
Troubleshooting
- The chart is blank or has only one point. Confirm that the X and Y cells contain numbers, not text that looks like numbers, and that the selected ranges have the same number of rows. In Chart Design > Select Data, edit the main series and check that its X values point to column B and its Y values to column C.
- The divider lines do not appear. Open Chart Design > Select Data and make sure both helper series are listed. Edit each series to confirm that the X and Y ranges are correct. Then check that its line is set to solid, its markers are set to None, and the axis bounds include both endpoints.
- A divider appears diagonal or in the wrong quadrant. Verify the order of the helper values. The vertical series must have the same X value twice and two different Y values. The horizontal series must have two different X values and the same Y value twice. Also confirm that the chart is XY (Scatter), not a category chart.
- The original points are joined by a line. Right-click the main series, choose Format Data Series, and set its line to No line. Do not turn off markers for that series; markers are what show the observations.
- Some points are cut off or the lines stop early. Check the minimum and maximum bounds on both axes. Increase the bounds if you want to show the full data range, and extend the helper endpoints to the new bounds so each divider still reaches across the plot area.
- The chart looks distorted. A square chart area does not guarantee equal numeric scales. If equal visual distances matter, use matching axis ranges and adjust the plot area dimensions. If the measures have different units, prioritize accurate scales and explain the axes instead of forcing them to look identical.
Frequently Asked Questions
Can I make a 4-quadrant graph without helper tables?
Yes. You can set the horizontal and vertical axes to cross at chosen values in their Format Axis settings, but those axis lines may look different from custom divider lines and can affect where the axes appear. Helper series are easier to style independently and make the intended thresholds explicit.
Can the two dividing lines use different thresholds?
Yes. Choose an X threshold and a Y threshold separately. Repeat the X threshold in both vertical-series X cells, and repeat the Y threshold in both horizontal-series Y cells. Set each axis scale so the line endpoints fit within the plot area.
How do I add names next to the dots?
Select the plotted data series and add data labels from Chart Design > Add Chart Element > Data Labels. In the label formatting options, choose values from cells if that control is available, then select the item-name range. You can also use labels for X or Y values, but those show numbers rather than item names.
Will the graph update when I change a score?
Yes, if the chart series refer to the cells you edit. Changing an existing X or Y value moves its point. If you add new rows, expand the chart’s source ranges or convert the source data into an Excel table and verify that the chart includes the new records. The helper series remain two endpoints each unless you change the thresholds or bounds.
Can I use negative values?
Yes. Use an XY scatter chart, choose axis minimum and maximum bounds that include the negative and positive values, and set the helper endpoints to those bounds. The threshold can be zero or another meaningful value. For example, a vertical series at X = 0 uses zero for both X values and the selected lower and upper Y bounds for its endpoints.
Related
- Unable to Unhide Rows in Excel? Try These Fixes
- How to Insert a Row in Excel Between Existing Data
- How to Unhide Rows in Excel That Won’t Unhide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Dual Axis Line Chart in Excel: Create and Format ItTo make a dual axis line chart in Excel for Microsoft 365 on Windows, select your data, then…
- Combo Pivot Chart in Excel: What Works and HowA combo PivotChart cannot be created directly in Excel for Microsoft 365: PivotCharts do not support combining chart…
- Can You Create a Pie Chart in Google Sheets? Here’s HowYes. In Google Sheets in a web browser, select a table of category names and values, choose Insert…
- Excel Pivot Table: Add a Calculated Column or FieldYes—but the right method depends on what you mean by a calculated column. In Excel for Microsoft 365…
- How to Make a Percentage Chart in Excel (With Labels)To make a percentage chart in Excel, select your category labels and percentage values, then choose a chart…
- Excel Half-Moon Chart: Add Red, Yellow, and Green ZonesTo create a red, yellow, and green half-moon chart in Excel, make a doughnut chart from three equal…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.