Fix Disabled Excel Chart Horizontal-Axis Move Options in WPS Office Spreadsheet
Question details
The user needs to know why Excel chart horizontal-axis move or rearrange commands are greyed out and how to reorder the category axis.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user selected an Excel chart and tried to move or rearrange the horizontal axis labels, but the related commands are unavailable.
- Observed behavior
- The horizontal-axis move options are disabled or greyed out, preventing direct axis rearrangement.
Open the workbook in WPS Office Spreadsheet and click the chart once so the Chart Tools tabs appear. Make sure you can see the horizontal axis labels, because selecting the chart area or a data series instead of the axis can disable the axis-specific commands.
Reorder the Horizontal Category Axis Labels with Select Data
Use this when you need to change the order of categories on a column, bar, or line chart and the axis move commands appear disabled.
In most Excel charts, the horizontal axis is a category axis. The move commands are disabled when the chart area, plot area, or a data series is selected, or when the chart type does not support category axis reordering.
Click the chart border to select the whole chart, then click directly on the horizontal axis labels so only the axis is selected rather than the chart area or a data series.
Go to Chart Tools > Chart Design on the ribbon, then click Select Data in the Data group.
In the Select Data Source dialog, find Horizontal (Category) Axis Labels and click Edit.
Type or select the worksheet range that contains the categories in the order you want, then click OK.
Click OK in the Select Data Source dialog and check that the horizontal axis now shows the intended category order.
Work Around XY Scatter Chart Axis Limitations
Use this if the chart is an XY Scatter chart, where horizontal category move commands are unavailable by design.
Reorder Excel Chart Horizontal-Axis Categories in WPS Office Spreadsheet
Open the workbook in WPS Office Spreadsheet, use Chart Tools > Select Data to edit the Horizontal (Category) Axis Labels, and save the file in Excel-compatible .xlsx format.
- 1. Open the Excel file: Launch WPS Office Spreadsheet and open the workbook that contains the chart.
- 2. Open Select Data: Click the chart, then go to Chart Tools > Chart Design on the ribbon and click Select Data.
- 3. Edit horizontal category labels: In the Select Data Source dialog, click Edit for Horizontal (Category) Axis Labels and choose the category range in the desired order.
- 4. Apply and save: Click OK to apply the change, then save the file as an Excel .xlsx workbook to preserve compatibility.
Frequently Asked Questions
Why are the horizontal-axis move options disabled in my Excel chart?
Usually only the chart area or a data series is selected, or the chart is an XY Scatter chart. Select the actual horizontal axis labels, then use Chart Design > Select Data to change the category range.
How do I reorder horizontal category labels in WPS Office Spreadsheet?
Select the chart, go to Chart Tools > Chart Design > Select Data, click Edit under Horizontal (Category) Axis Labels, and choose the category range in the new order.
Can I enable category axis move options for an XY Scatter chart?
No. XY Scatter charts use numeric horizontal values rather than categories. Switch to Column, Bar, or Line, or reorder the source data rows to change the plotted order.
Why does changing the chart area not enable axis commands?
Axis-specific commands appear only when the axis itself is selected. Click directly on the horizontal axis labels rather than the chart border or a data series.
Will edits made in WPS Office remain compatible with Microsoft Excel?
Yes. WPS Office Spreadsheet saves to Excel .xlsx format, so the chart and axis changes open normally in Microsoft Excel.
