Chart & Visualization Issues

Change the Axis Label Interval on an Excel Line Chart

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user wants to change how frequently axis labels appear on an Excel line chart.

Change the Axis Label Interval 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the axis

Click the line chart, then click the horizontal axis labels you want to change.

2
Open axis formatting

Right-click the selected axis and choose Format Axis, or use the chart Format tab and select Format Selection.

3
Set the label interval

In the Format Axis pane, open Axis Options, expand Labels, and choose Specify interval unit under Interval between labels. Enter 5.

Show Every Fifth Category Label in Excel
Category interval: An interval of 5 shows every fifth category label; it does not necessarily mean that the displayed values are five numeric units apart.
WPS Spreadsheet

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. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select the chart axis: Click the line chart, then right-click the axis whose labels you want to change.
  3. 3. Open axis settings: Choose Format Axis and open Axis Options. The available controls may vary by axis type and WPS version.
  4. 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. 5. Save the workbook: Use File > Save As to save the edited chart in your preferred workbook format.
Control the spacing of line chart axis labels.Open and edit Microsoft Excel XLSX and XLS files.Work with charts in a familiar spreadsheet interface.Use WPS Office for free.
microsoft office alternative - wps office

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.