Chart & Visualization Issues

Move Negative Bar Chart Category Labels to the Right in Excel

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user wants to move bar chart category labels to the right so they are not hidden by negative bars.

Move Negative Bar Chart Category Labels to the Right in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Format Axis

Double-click a category label or the vertical category axis in the bar chart to open the Format Axis pane.

2
Find label settings

In the Format Axis pane, select Axis Options and expand Labels.

3
Move labels right

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.

Set the Excel category axis label position to High
Category labels versus data labels: This setting moves the category axis labels, not the numeric values displayed on individual bars.
Edit charts in WPS Office

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. 1. Open the workbook: In WPS Spreadsheets, open the Excel workbook containing the bar chart.
  2. 2. Select the category axis: Click the chart, then right-click a vertical category axis label and choose Format Axis.
  3. 3. Change the label position: In the axis formatting options, expand Labels and set Label Position to High.
  4. 4. Save the workbook: Check that the labels appear on the right, then use File > Save or Save As to save the workbook.
Adjust category axis labels to keep them clear of negative barsOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet and chart formatting controlsWork with a free, easy-to-use office suite
QA img-9

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.