To add a grid to an Excel scatter plot, select the chart, then choose Chart Design > Add Chart Element > Gridlines and select the horizontal or vertical major gridlines you need. You can add minor gridlines for finer spacing, then format their appearance or adjust the axis scale to make the data easier to read.
What gridlines show on a scatter plot
A scatter plot positions each point using two numeric values: one on the horizontal (X) axis and one on the vertical (Y) axis. Gridlines extend across the chart from the axis tick marks. They help readers estimate a point’s coordinates without having to rely only on the axis labels.
Horizontal gridlines align with values on the Y-axis. Vertical gridlines align with values on the X-axis. For example, if a scatter plot compares hours studied with test scores, vertical lines can help estimate study hours, while horizontal lines help estimate scores. The lines are visual guides; they do not change the values or calculations in the worksheet.
Excel can show major gridlines, which align with the main axis labels, and minor gridlines, which divide the space between major intervals. A chart does not need every available gridline. Too many lines can compete with the points and make a chart harder to interpret.
Add or remove gridlines in Excel
These steps apply to Excel for Microsoft 365 on Windows. First click the scatter plot so Excel displays the chart tabs. Then use the ribbon:
- Select the chart and open Chart Design.
- Choose Add Chart Element > Gridlines.
- Select an option such as Primary Major Horizontal or Primary Major Vertical.
- Repeat the steps to add another direction or a minor gridline set.
To remove a set, return to the same Gridlines menu and click the checked option. You can also click an individual gridline in the chart and press Delete, but selecting a specific line can be tricky when the chart has several sets. The menu is usually the more reliable way to turn an entire set on or off.
Another route is to select the chart, click the green Chart Elements plus button beside it, and point to Gridlines. Use the arrow beside that option to choose particular types. The plus button may not appear in every Excel interface or screen arrangement; the Chart Design ribbon provides the main route.
Choose major or minor gridlines
Major gridlines are the best starting point for most charts. They correspond to the numbered tick marks on an axis, so readers can relate a point to the scale. A scatter plot with major horizontal lines only can be easier to scan when the Y-values matter most. Add vertical lines too when estimating X-values is equally important.
Minor gridlines add smaller divisions between major lines. They can help when the chart covers a narrow range or when readers need to estimate values more precisely. But they are not automatically more accurate: the plotted coordinates are unchanged, and a reader is still estimating visually. If minor lines make the chart look like graph paper, remove them or use a lighter line style.
- Use major horizontal lines to compare vertical values across points.
- Use major vertical lines to estimate horizontal values.
- Add minor lines only when the scale and task justify the extra detail.
- Leave a direction off if it adds clutter without helping interpretation.
The available gridline choices depend on the chart and its axes. In a standard scatter chart with both axes displayed, Excel provides horizontal and vertical gridline options. If an axis or gridline option is missing, check that the selected object is the chart and that the chart type is an XY scatter chart rather than a line chart.
Format gridline color, weight, and style
To change the appearance of a set of gridlines, select one of its lines, right-click, and choose Format Gridlines. Excel opens a formatting pane. Under Fill & Line, use the line controls to choose a color, width, transparency, or dash type. The exact controls can vary slightly with the Excel build and the selected line.
Gridlines generally work best as quiet references behind the data. A pale gray, thin solid line is often more readable than a dark or thick line. If points are small or numerous, keep lines subtle so they do not appear to connect the markers. If a line is difficult to select, click near its middle rather than at an intersection, or use the chart’s current selection controls to choose a gridline element.
Formatting one set does not necessarily format every other set. Horizontal major lines, vertical major lines, and minor lines can be separate chart elements. Check each set after changing the style, especially if the chart uses both major and minor lines. You can also use Chart Design > Change Colors for chart color schemes, but that is not a substitute for setting the gridline style directly when you need a specific contrast or line weight.
Control grid spacing with axis settings
Gridline spacing comes from the axis scale, not from dragging the lines individually. To change it, right-click the relevant axis labels and choose Format Axis. In the pane, look under Axis Options for the bounds and units. For a value axis, you can set minimum and maximum bounds and the major unit; where available, set a minor unit as well. The major gridlines follow the major unit, and minor gridlines follow the minor unit.
For example, suppose the horizontal axis ranges from 0 to 100 and its major unit is 20. Major vertical gridlines will align with 0, 20, 40, 60, 80, and 100, subject to how the chart draws its plot area and edges. Changing the major unit to 10 produces more frequent reference lines. If the vertical axis runs from 0 to 50 with a major unit of 10, its major horizontal lines align with those Y-values.
Automatic bounds and units are often sensible for a quick chart. Set them manually when consistent scales matter, such as comparing two plots side by side, or when Excel’s automatic intervals make the data difficult to judge. Avoid choosing a narrow axis range just to make differences look dramatic; the scale should make the chart informative without misleading the reader. You can restore Excel’s automatic behavior by changing a manually entered bound or unit back to Auto, when that control is shown.
Check the data and chart type
Gridlines cannot correct a chart that is using the wrong data arrangement. A typical scatter plot uses one numeric column for X-values and another numeric column for Y-values, with each row representing a paired observation. Select those columns, then use Insert > Insert Scatter (X, Y) or Bubble Chart and choose a scatter subtype. If the chart plots categories at evenly spaced positions instead of numeric X-values, check whether Excel created a line chart rather than an XY scatter chart.
For instance, a table with distance in column A and time in column B can produce points where each distance is paired with the time in the same row. If Excel assigned the wrong ranges, right-click the chart and choose Select Data, select the series, and choose Edit to inspect the series X values and series Y values. Correcting the series ranges often resolves an apparent mismatch between the points and the grid.
Blank cells, text stored in numeric columns, and inconsistent units can also make the plot confusing. Confirm that both axes use the intended measurement units and that the values are numeric. Gridlines are simply visual references; they will not reveal whether a series has been assigned the wrong columns or whether one value is expressed in different units.
Common gridline problems and fixes
- No gridlines appear: Select the chart, not an individual data point, and use Chart Design > Add Chart Element > Gridlines. Check that the desired option is enabled.
- Lines are too close together: Right-click the relevant axis, choose Format Axis, and review its major or minor unit. A smaller unit creates more frequent lines; a larger unit creates fewer.
- Only one direction is visible: Add the other direction separately. Horizontal and vertical gridlines are independent choices.
- Lines obscure the markers: Use a lighter color, thinner width, or fewer gridline sets. Also check that the data series markers have enough contrast against the plot area.
- Spacing seems uneven: Check whether the axis is logarithmic or whether the scale and units differ from what you expected. On a logarithmic axis, equal visual distances represent multiplicative changes rather than equal numerical increments.
When you adjust axis bounds, look again at the data points and labels. A grid may look tidy while omitting important values outside the chosen bounds. If the chart is intended for print or a report, inspect it at its final size: thin lines that look clear on screen can disappear when printed or reduced.
Gridlines versus worksheet cells and data tables
Chart gridlines are not the same as the gridlines on an Excel worksheet. Worksheet gridlines divide cells on the sheet; chart gridlines belong to the chart’s plot area and follow its axes. Hiding worksheet gridlines through View > Show > Gridlines does not turn off the chart’s gridlines. Likewise, formatting chart gridlines does not change the worksheet view.
Gridlines are also different from a chart data table. A data table displays the source values beneath a chart, while gridlines help estimate values from the plotted position. If exact readings matter, show labels or provide the underlying data rather than expecting readers to infer precise numbers from the lines. For many scatter plots, a few clear axis labels and unobtrusive gridlines are enough.
Frequently Asked Questions
How do I add gridlines to an Excel scatter plot?
Select the chart, then choose Chart Design > Add Chart Element > Gridlines. Pick the horizontal or vertical major or minor gridline option you want.
How do I add vertical gridlines to a scatter plot?
Select Primary Major Vertical from the Gridlines menu. These lines align with the horizontal X-axis values. For finer divisions, choose the primary minor vertical option if it is available.
Why are my scatter plot gridlines uneven?
Check the axis scale and unit settings. A logarithmic axis spaces values by powers rather than equal additions, so equal visual intervals do not correspond to equal numeric differences.
Can I change the spacing between gridlines?
Yes. Right-click the corresponding axis, choose Format Axis, and adjust the major unit or, if available, the minor unit. Gridlines follow those axis intervals.
Do Excel chart gridlines print?
Chart gridlines are part of the chart and normally print with it. Preview the worksheet or printed page, since very light or thin lines may be hard to see at the final print size.
Are the steps different on a Mac or in Excel for the web?
The chart concepts are the same, but ribbon placement and available controls can differ by platform and version. On Mac, select the chart and use the chart design controls to add gridlines; in Excel for the web, some detailed formatting options may be more limited than in the Windows desktop app.
Related
- Excel Print a Certain Area: Set a Print Area
- Excel Printer Not Responding? Troubleshoot the Problem
- Excel Problem Solver: How to Set Up Solver
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Auto Updating Formulas? Fix It NowIf your Excel formulas are not auto-updating, the most likely cause is that calculation is set to Manual…
- Excel VLOOKUP Not Working? Fix the Common CausesIf VLOOKUP is returning an error or the wrong result, check that the lookup value is in the…
- Transpose Formula in Excel Not Working? FixesIf your Excel TRANSPOSE formula is not working, first check whether its output cells are clear and whether…
- Excel Freeze Panes Not Working on Selection? Fix ItIf Excel Freeze Panes is not working on your selection, first select the cell immediately below the rows…
- Excel All Cells Must Be the Same Size Error ExplainedThe Excel message “To do this, all the merged cells need to be the same size” usually means…
- Excel Cell Formula Not Working? Fix the Common CausesIf an Excel formula is not working, first check that the cell is formatted as General, the formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.