Chart & Visualization Issues

Excel Chart Axis Labels: Change Label Angles and Year Intervals

John WilsonJohn Wilson Nov 12, 2026 870 views

Question details

The user needs to rotate horizontal chart-axis labels and control how frequently year values appear on the axis.

Excel Chart Axis Labels: Change Label Angles and Year Intervals
Product
Microsoft Excel chart
Device & OS
not provided
Scenario
The chart contains crowded or unclear X-axis labels, and the user wants to display years at a chosen interval.
Observed behavior
The horizontal-axis label angle and the spacing between displayed year values are not set to the desired format.
Before you start

Select the chart and identify whether the horizontal axis is a date axis or a category axis. The available interval controls differ by chart type.

Solution 1Recommended

Format the Excel axis to rotate labels and set year intervals

Use this method when you need to improve label readability and control the frequency of year values shown on a chart.

Excel uses different controls for date axes and category axes. Date axes generally use Major unit and Base unit values, while category axes use a label interval setting.

1
Open Format Axis

Right-click the chart's horizontal X-axis and select Format Axis from the context menu.

2
Set the label angle

In the Format Axis pane, open Alignment or Text Options, locate the custom text angle setting, and enter an angle such as -45 degrees.

3
Choose the year interval for a date axis

If the axis is a date axis, open Axis Options and set the Base unit to Years when available, then enter the desired value in Major unit, such as 2 to show every two years.

4
Set the label interval for a category axis

If the axis is a category axis, expand Labels in the Format Axis pane and set Specify interval unit to the number of categories or years to skip between displayed labels.

Chart type affects the available settings: If Major unit or Base unit is unavailable, the chart is likely using category labels rather than a date axis. Use the category-axis label interval instead.

Adjust chart label angles and year intervals in WPS Spreadsheet

WPS Spreadsheet provides chart formatting controls for rotating X-axis labels and adjusting date-axis units or category-label intervals, helping you create clearer charts without changing the source data.

  1. 1. Select the chart axis: Open the workbook in WPS Spreadsheet, click the chart, and select the horizontal X-axis.
  2. 2. Open axis formatting: Right-click the selected axis and choose Format Axis to open the chart-axis settings pane.
  3. 3. Change the text angle: Open the Alignment or Text Options section and enter a custom text angle, such as -45 degrees.
  4. 4. Set the year spacing: For a date axis, use Axis Options to set the Base unit to Years and adjust Major unit. For a category axis, use the label interval setting instead.
Rotate crowded chart labels to a readable angle.Control how many years or categories appear between axis labels.Use familiar chart and Format Axis controls for quick adjustments.Open and edit Microsoft Excel XLS and XLSX chart files with compatible formatting.
microsoft office alternative - wps office

Frequently Asked Questions

How do I rotate X-axis labels in Excel?

Right-click the horizontal axis, choose Format Axis, open Alignment or Text Options, and enter a custom text angle such as -45 degrees.

Why can’t I find the Major unit setting for my chart?

Major unit is typically available for date axes. If the chart uses category labels, open the Labels section in Format Axis and use Specify interval unit instead.

How can I show every second or third year on a chart axis?

For a date axis, set the Base unit to Years and enter 2 or 3 in Major unit. For a category axis, set Specify interval unit to 2 or 3.

Does changing the axis interval remove the underlying data?

No. Changing the major unit or label interval only controls which axis labels are displayed; the chart data and plotted values remain unchanged.