Show Excel Chart Gridlines and Y-Axis Labels at Different Intervals
Question details
Set Excel chart gridlines and Y-axis labels to appear 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.
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.
Use Major and Minor Units for Different Chart Intervals
Set the Y-axis major unit for labels and the minor unit for additional gridlines.
Select the chart, right-click the Y-axis, and choose Format Axis.
Under Axis Options, find Units and set Major to twice Minor. For example, enter 20 for Major and 10 for Minor.
Select the chart, then choose Chart Design > Add Chart Element > Gridlines. Enable Primary Major Horizontal and Primary Minor Horizontal.
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.

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. Open the workbook: Open WPS Spreadsheets and choose File > Open to select your workbook.
- 2. Format the vertical axis: Select the chart, right-click its Y-axis, and choose Format Axis.
- 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. 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.

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.




