Excel Chart Gridline Interval: How to Set It

In Excel for Microsoft 365 on Windows, set a chart’s gridline interval by formatting the axis that the gridlines belong to: right-click that axis, choose Format Axis, then enter a value for Major under Units. For finer spacing, set a Minor unit and turn on minor gridlines separately. The right setting depends on whether the axis shows numbers, dates, or categories.

What a chart gridline interval means

A gridline interval is the distance between successive gridlines on a chart. On a numeric value axis, it is usually a numerical amount: an interval of 20 produces major gridlines 20 units apart. On a date axis, the interval may be expressed in days, months, or years. On a category axis, the relevant control is generally how often Excel places ticks or labels across the categories.

Gridlines are visual guides, not data marks. Changing their interval does not change the values in the worksheet or the plotted data. It changes the chart’s scale or the frequency of reference lines so readers can estimate values more easily. Excel often chooses an interval automatically, aiming for a readable number of lines. That automatic choice can be convenient, but it may not suit a chart that needs consistent increments across reports or an exact comparison.

One important distinction: the axis controls the interval, while the gridline controls whether those lines are displayed and how they look. If the interval setting appears to have no effect, the corresponding gridlines may not be enabled.

Set the interval on a numeric value axis

For a column or line chart with a numeric vertical axis, horizontal gridlines are tied to that value axis. To set their spacing in Excel for Microsoft 365 on Windows:

Select the chart, then right-click the vertical value-axis labels, such as 0, 20, and 40.
Choose Format Axis. The Format Axis pane opens.
Under Axis Options, find Units.
Change Major from Auto to the interval you want. For example, enter 20 to use major increments of 20.
If needed, set Minor to a smaller increment, such as 5, and add minor gridlines through the chart’s gridline controls.

Suppose a chart runs from 0 to 100 and its major unit is 20. Its major gridlines will normally align with 0, 20, 40, 60, 80, and 100. If the axis bounds are automatic, Excel may adjust the minimum or maximum to create a clean scale; the exact visible endpoints depend on the data and the bounds. For a controlled report, set the axis minimum and maximum as well as the major unit, when appropriate.

To display the lines, select the chart and use Chart Design > Add Chart Element > Gridlines, then choose the relevant major or minor gridline direction. You can also use the chart’s Chart Elements button, shown as a plus sign beside a selected chart, where available. The wording and available choices can vary with chart type.

Choose an interval that fits the data

The best interval is large enough to keep the chart uncluttered but small enough to help someone estimate values. Consider the data range, the chart’s physical size, and the precision the reader needs. A small chart with many narrow gridline gaps can look crowded; a wide interval can make differences hard to judge.

For a 0–100 scale: intervals of 10 or 20 are common starting points. Use 10 when readers need more detail; use 20 when the chart should feel cleaner.
For values around 0–1,000: an interval of 100 or 200 may be easier to read than dozens of closely spaced lines.
For small decimal values: choose an interval that matches the meaningful precision, such as 0.1 rather than 0.01 if hundredths are not important.
For comparisons across charts: use the same bounds and major unit on each chart when readers need to compare magnitudes directly.

These are examples, not universal rules. A chart of scientific measurements may need fine divisions, while a presentation chart may need fewer. Avoid adding minor gridlines just because Excel offers them: if they compete with the data series, reduce their visual prominence or leave them off.

Category axes, date axes, and scatter charts

Not every chart axis uses a numeric major-unit field. In a column chart with product names along the bottom, the horizontal axis is a category axis. To change how often categories receive labels or tick marks, right-click that axis and choose Format Axis. Depending on the chart and axis options, the pane includes controls such as Interval between labels and Interval between tick marks. For example, showing every second label can make a long list easier to scan. This is not the same as changing the numerical spacing of the vertical value axis.

Date axes treat dates as positions on a timeline. In Format Axis, Excel may let you choose a base unit such as days, months, or years, then specify the interval in that unit. If monthly data should show one major division per quarter, set the date-axis interval to three months where that option is available. The exact controls depend on whether Excel recognizes the horizontal values as dates and on the chart type. If the dates behave like ordinary text categories, check the source cells and the axis type.

An XY (scatter) chart has numeric horizontal and vertical axes. To change vertical gridline spacing, format the horizontal value axis; to change horizontal gridline spacing, format the vertical value axis. In other words, gridlines run across the plot area, but their positions are determined by the perpendicular axis. This is a frequent source of confusion when a chart has gridlines in both directions.

Major and minor gridlines are separate choices

Major gridlines correspond to the major units on an axis. Minor gridlines, when available and enabled, subdivide the space between major divisions. For instance, with a major unit of 20 and a minor unit of 5, minor divisions can mark steps between the major lines. The major and minor unit values should be compatible with the intended scale; a minor unit larger than the major unit will not create the expected finer subdivisions.

Setting a minor unit alone does not necessarily make minor lines visible. Add minor gridlines from Chart Design > Add Chart Element > Gridlines, or select and format existing gridlines. You can adjust their line color, width, or transparency so they remain subordinate to the major lines. For many business charts, major gridlines are enough; minor lines are more useful when precise visual reading matters.

Gridline interval versus axis labels and bounds

Several nearby settings affect how a chart looks, but they do different jobs:

Major unit: controls the spacing of major divisions on a numeric axis and the associated major gridlines.
Minor unit: sets subdivisions between major divisions when minor features are used.
Minimum and maximum bounds: determine the displayed axis range. They do not, by themselves, specify the interval.
Label interval: controls how frequently category labels are displayed. It does not change the underlying data or the numeric scale.
Gridline formatting: changes the appearance of lines, not their positions.

For example, setting a vertical axis minimum to 0 and maximum to 100 does not guarantee gridlines every 10. The major unit must also be set to 10 if that spacing is required. Conversely, setting a major unit of 10 while leaving bounds automatic can produce a sensible scale whose visible endpoints differ from the exact values you expected.

Common problems and how to fix them

The interval box is missing: You may have selected a category axis rather than a numeric value axis. Select the other axis, or use the category-axis interval controls if you are adjusting label or tick frequency.
Changing the unit does not show more lines: Check that major gridlines are turned on. If you changed the minor unit, make sure minor gridlines are enabled too.
The chart’s scale changes unexpectedly: Excel may be using automatic axis bounds. Set the minimum and maximum explicitly if a fixed range is essential, then choose a compatible major unit.
Dates are spaced oddly: Confirm that the source cells contain real Excel dates and that the chart is using a date axis where appropriate. Text that looks like a date may be treated as categories.
You changed the wrong set of lines: Horizontal gridlines are controlled by the vertical axis; vertical gridlines are controlled by the horizontal axis. In a scatter chart, both axes are numeric, so select the axis that determines the direction you want.
A secondary axis has different spacing: A chart with a secondary axis has separate axis settings. Format the axis associated with the series and gridlines you intend to adjust.

Excel for Mac uses the same general approach: select the chart axis and open its formatting pane, then adjust the relevant unit or interval. Ribbon labels and pane layout may differ slightly by platform or update. Excel for the web can handle common chart edits, but if a particular axis control is unavailable in the browser, open the workbook in the desktop app to use the full formatting pane.

When to use fixed or automatic spacing

Automatic spacing is often the right choice for a one-off chart because Excel can adapt the scale as the data changes. Fixed spacing is more useful when a chart must follow a reporting standard, when several charts are compared side by side, or when readers expect familiar increments. A fixed major unit can also preserve a consistent visual rhythm as values are updated, but it can become unsuitable if the data range changes substantially.

Check a chart after new data is added. If the values now extend far beyond the previous range, a formerly useful fixed interval may create too many lines or leave the plot area compressed. If the values become much smaller, the old bounds can make meaningful variation difficult to see. Consistent scales improve comparison, but they should still make the data legible.

Frequently Asked Questions

How do I change the spacing between gridlines in Excel?
Right-click the axis that determines the gridline positions, choose Format Axis, and set the Major unit under Units. Make sure the corresponding gridlines are displayed.

Can I set Excel chart gridlines to every 5 units?
Yes, if the axis is numeric. Set its major unit to 5 in the Format Axis pane. If the axis range is small, check that the resulting number of lines remains readable.

Why can’t I find the major unit setting?
You may have selected a category axis, which uses label or tick intervals rather than numeric units. Select the value axis instead. Some chart types also expose different options.

How do I add minor gridlines in Excel?
Set a minor unit in the axis options where available, then add minor gridlines using Chart Design > Add Chart Element > Gridlines. The setting and display choice are separate.

Do gridline intervals change my chart data?
No. They affect the chart’s scale or visual reference lines, not worksheet values. Changing axis bounds or units changes how the data is displayed, not the source data itself.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.