Chart & Visualization Issues

Rotate Bar Chart Category Labels to Horizontal in Excel

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

Change the vertical category-axis labels in an Excel bar chart so they appear horizontally at 0 degrees.

Rotate Bar Chart Category Labels to Horizontal in Excel
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.
Before you start

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.

Solution 1Recommended

Set the Excel category-axis label angle to 0 degrees

Use the Format Axis pane to make the vertical-axis category labels horizontal.

1
Select the category labels

Click the bar chart, then right-click one of the category names along the vertical axis.

2
Open axis formatting

Choose Format Axis from the right-click menu.

3
Set the label orientation

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.

4
Check the chart

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.

Set the Excel category-axis label angle to 0 degrees
Menu names may vary: The location of text alignment settings can differ between Excel versions.
Adjust chart labels in WPS

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Select the axis: Click the bar chart, then right-click a category label on the vertical axis.
  3. 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. 4. Review and save: Check the labels on the chart, then use File > Save As to save the workbook in the desired format.
Adjust bar chart category-label orientationOpen and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet charts in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

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.