Move Negative Bar Chart Category Labels to the Right in Excel
Question details
The user wants to move bar chart category labels to the right so they are not hidden by negative bars.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A horizontal bar chart contains both positive and negative values.
- Observed behavior
- Category labels appear near the vertical axis and can be obscured by negative bars.
Open the workbook and select the bar chart. Identify the category labels on the vertical axis; these are different from the numeric data labels on the bars.
Set the Excel category axis label position to High
Use the Format Axis pane to move category labels to the right side of the chart.
Double-click a category label or the vertical category axis in the bar chart to open the Format Axis pane.
In the Format Axis pane, select Axis Options and expand Labels.
Open the Label Position list and select High. The category labels will appear on the opposite side of the axis, at the right of the chart.

Move bar chart category labels in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use the category axis formatting options to place bar chart labels on the right.
- 1. Open the workbook: In WPS Spreadsheets, open the Excel workbook containing the bar chart.
- 2. Select the category axis: Click the chart, then right-click a vertical category axis label and choose Format Axis.
- 3. Change the label position: In the axis formatting options, expand Labels and set Label Position to High.
- 4. Save the workbook: Check that the labels appear on the right, then use File > Save or Save As to save the workbook.

Frequently Asked Questions
Why are my category labels covered by negative bars?
The labels may be positioned next to the vertical axis, where bars extending left from zero can overlap them. In Format Axis, expand Labels and set Label Position to High.
Does changing the axis label position move the bar values too?
No. Label Position changes category axis labels. To adjust numeric data labels, select a data label and open Format Data Labels.
How do I put the category labels back near the axis?
Double-click a category label, expand Labels in the Format Axis pane, and set Label Position to Next to Axis.
Will moving the category labels change the chart data?
No. Selecting High under Format Axis > Labels changes where the labels appear; it does not change the worksheet values.




