Rotate Bar Chart Category Labels to Horizontal in Excel
Question details
Change the vertical category-axis labels in an Excel bar chart so they appear horizontally at 0 degrees.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants category names on a bar chart's vertical axis to read horizontally.
- Observed behavior
- The desired result is for the category labels to appear horizontally rather than rotated.
Open the workbook and locate the bar chart. Identify the category names along the vertical axis so you can select the labels rather than the axis title or data series.
Set the Excel category-axis label angle to 0 degrees
Use the Format Axis pane to make the vertical-axis category labels horizontal.
Click the bar chart, then right-click one of the category names along the vertical axis.
Choose Format Axis from the right-click menu.
In the Format Axis pane, open Text Options and look for Text Box or Alignment. Set Custom angle to 0 degrees and, if available, set Text direction to Horizontal.
Click outside the Format Axis pane and check that the category names are horizontal. If they remain rotated, select the labels again and verify the chart type and available axis label settings.

Make bar chart labels horizontal in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use the chart axis formatting controls to change category label orientation.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select the axis: Click the bar chart, then right-click a category label on the vertical axis.
- 3. Change the orientation: Choose Format Axis and look for the text alignment or orientation controls. Set the text direction to Horizontal or the custom angle to 0 degrees, if available.
- 4. Review and save: Check the labels on the chart, then use File > Save As to save the workbook in the desired format.

Frequently Asked Questions
How do I select the category axis instead of the chart title?
Right-click one of the category names beside the bars, not the chart title or a bar. Then choose Format Axis.
Where is the custom angle setting in Excel?
Right-click the category labels and choose Format Axis. In the pane, look under Text Options for Text Box or Alignment; the exact location can vary by Excel version.
Why are my labels still rotated after I enter 0 degrees?
Check that you selected the category axis and that Text direction is set to Horizontal if that option is available. Also verify the chart type and its axis label settings.
Can I adjust these labels in WPS Spreadsheets?
Yes. Right-click the chart's category labels, choose Format Axis, and look for text alignment or orientation controls. Available settings can vary by WPS version.




