Chart & Visualization Issues

Show Excel Chart Gridlines and Y-Axis Labels at Different Intervals

Bushra ParveenBushra Parveen Nov 14, 2026 869 views

Question details

Set Excel chart gridlines and Y-axis labels to appear at different intervals.

Show Excel Chart Gridlines and Y-Axis Labels at Different Intervals
Product
Microsoft Excel
Device & OS
not provided
Scenario
A chart needs horizontal gridlines at a smaller interval than its Y-axis labels.
Observed behavior
The desired chart shows a gridline at each minor interval and a Y-axis label at each major interval.
Before you start

Select a chart with a numeric vertical axis and decide the intervals you want. For example, use a major unit of 20 and a minor unit of 10 to show a label at every other gridline.

Solution 1Recommended

Use Major and Minor Units for Different Chart Intervals

Set the Y-axis major unit for labels and the minor unit for additional gridlines.

1
Open axis settings

Select the chart, right-click the Y-axis, and choose Format Axis.

2
Set the units

Under Axis Options, find Units and set Major to twice Minor. For example, enter 20 for Major and 10 for Minor.

3
Show both gridline types

Select the chart, then choose Chart Design > Add Chart Element > Gridlines. Enable Primary Major Horizontal and Primary Minor Horizontal.

4
Check the chart

Review the Y-axis labels and horizontal gridlines. With major and minor units of 20 and 10, labels appear at major intervals while gridlines also appear at the intervals between them.

Use Major and Minor Units for Different Chart Intervals
Align intervals with zero: If you want labels at 0, 20, 40, and so on, set the Y-axis minimum bound to 0 under Format Axis > Axis Options.
WPS Spreadsheets

Adjust Chart Gridlines in WPS Spreadsheets

Use WPS Spreadsheets to adjust a chart's vertical-axis units and display major and minor horizontal gridlines.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose File > Open to select your workbook.
  2. 2. Format the vertical axis: Select the chart, right-click its Y-axis, and choose Format Axis.
  3. 3. Adjust the units: In Axis Options, set the major unit to the desired label interval and the minor unit to the desired gridline interval, such as 20 and 10.
  4. 4. Enable gridlines: Select the chart and use the chart elements or gridlines controls to enable both major and minor horizontal gridlines. Available controls can vary by WPS version.
Show chart gridlines more frequently than Y-axis labelsOpen and edit Microsoft Excel XLS and XLSX filesWork with charts in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

How do I show a gridline between each Y-axis label?

Right-click the Y-axis and select Format Axis. Set the minor unit to half the major unit, then enable both major and minor horizontal gridlines from Chart Design > Add Chart Element > Gridlines.

Can I use intervals other than 20 and 10?

Yes. Under Format Axis > Axis Options, enter any suitable major and minor units. For example, major 100 and minor 25 show gridlines at quarter intervals between major labels.

Why don't my Y-axis labels start at zero?

Excel may choose the axis bounds automatically. Right-click the Y-axis, select Format Axis, and set the Minimum bound to 0 under Axis Options if zero is appropriate for your data.

How do I remove the extra gridlines?

Select the chart and choose Chart Design > Add Chart Element > Gridlines, then turn off Primary Minor Horizontal. The major horizontal gridlines can remain visible.