Change the Axis Label Interval on an Excel Line Chart
Question details
The user wants to change how frequently axis labels appear on an Excel line chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A line chart has labels at every category or numeric unit, and the user wants to show them at a wider interval.
- Observed behavior
- The chart should display every fifth category label or numeric labels five units apart, depending on the axis type.
Open the workbook and select the line chart. Determine whether you want to space category labels on the horizontal axis or change the numeric scale on a value axis.
Show Every Fifth Category Label in Excel
Use this method to reduce the number of labels shown on a category axis without removing data points.
Click the line chart, then click the horizontal axis labels you want to change.
Right-click the selected axis and choose Format Axis, or use the chart Format tab and select Format Selection.
In the Format Axis pane, open Axis Options, expand Labels, and choose Specify interval unit under Interval between labels. Enter 5.

Set a Value Axis to Five-Unit Increments in Excel
Use this method when the axis is numeric and labels should be spaced five units apart.
Adjust Line Chart Axis Labels in WPS Spreadsheet
Open your workbook in WPS Spreadsheet and use the axis formatting controls to space category labels or change a numeric axis's major unit.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select the chart axis: Click the line chart, then right-click the axis whose labels you want to change.
- 3. Open axis settings: Choose Format Axis and open Axis Options. The available controls may vary by axis type and WPS version.
- 4. Adjust the spacing: For a category axis, set the interval between labels to 5 if available. For a value axis, set the major unit to 5.
- 5. Save the workbook: Use File > Save As to save the edited chart in your preferred workbook format.

Frequently Asked Questions
Does changing the label interval remove data points?
No. Setting Interval between labels to 5 hides some category labels but leaves the chart's data points in place.
Why can't I find Interval between labels?
That setting is intended for category labels. If you selected a numeric value axis, open Format Axis > Axis Options and change the Major unit instead.
How do I show numeric labels at 0, 5, 10, and so on?
Right-click the value axis, choose Format Axis, and set the Major unit to 5 under Axis Options. Set the Minimum bound to 0 if appropriate for your data.
Can I change the spacing of date labels?
Yes. Right-click the date axis and choose Format Axis. Under Axis Options, adjust the major unit and date unit, such as days or months, if those controls are available.




