Excel Chart Axis Labels: Change Label Angles and Year Intervals
Question details
The user needs to rotate horizontal chart-axis labels and control how frequently year values appear on the axis.

- 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.
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.
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.
Right-click the chart's horizontal X-axis and select Format Axis from the context menu.
In the Format Axis pane, open Alignment or Text Options, locate the custom text angle setting, and enter an angle such as -45 degrees.
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.
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.
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. Select the chart axis: Open the workbook in WPS Spreadsheet, click the chart, and select the horizontal X-axis.
- 2. Open axis formatting: Right-click the selected axis and choose Format Axis to open the chart-axis settings pane.
- 3. Change the text angle: Open the Alignment or Text Options section and enter a custom text angle, such as -45 degrees.
- 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.

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.




