How to Change the X-Axis Values in Excel Online: Workaround and WPS Fix
Question details
The user wants to change the X-axis values or numeric scale in Excel Online but cannot find the full desktop Format Axis controls.

- Product
- Excel Online / Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- The user is editing a chart in Excel Online and needs to update the horizontal axis labels or numeric values.
- Observed behavior
- Excel Online does not expose the full Format Axis numeric controls, so changing the X-axis values directly is not available.
Open the workbook in Excel Online and click the chart to identify whether the X-axis uses worksheet labels or numeric values. If you need to change the numeric axis scale, plan to open the workbook in a desktop spreadsheet app such as WPS Office Spreadsheets or Microsoft Excel.
Change the X-Axis Values by Editing the Chart Source Cells in Excel Online
Use this workaround when you need to update the categories or labels shown on the X-axis and the chart is already open in Excel Online.
Excel Online updates a chart automatically when its source data changes. Editing the worksheet cells behind the chart is the fastest way to change X-axis labels without leaving Excel Online.
Open the workbook in Excel Online, click the chart to select it, and note the highlighted source data range around the worksheet cells.
Click the worksheet cells that contain the current X-axis labels or values, type the new values or labels, and press Enter.
Check the chart after editing. Excel Online updates the horizontal axis automatically from the edited source cells.
Adjust Numeric X-Axis Settings in Desktop Excel or WPS Office Spreadsheets
Use this method when you need to change numeric axis scale options such as minimum, maximum, or label interval that Excel Online does not expose.
Change Chart X-Axis Values in WPS Office Spreadsheets
WPS Office Spreadsheets gives you the desktop chart formatting controls that Excel Online lacks. Open the workbook in WPS Office, select the chart, and use Format Axis to set the X-axis values or numeric scale without paying for a desktop Office license.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets, click the Menu button in the top-left corner, choose Open, and select the Excel workbook you created in Excel Online.
- 2. Select the chart and open Format Axis: Click the chart to reveal the Chart Tools tabs. Right-click the horizontal X-axis and choose Format Axis from the context menu.
- 3. Set X-axis values or scale: In the Format Axis pane, use Axis Options to edit the value range, minimum, maximum, or label interval. To change the labels themselves, edit the chart source cells or use Select Data.
- 4. Save the updated workbook: Press Ctrl+S or click Menu > Save As to save the changes. The file remains compatible with Excel .xlsx format.

Frequently Asked Questions
Can I change the X-axis minimum value directly in Excel Online?
No. Excel Online does not expose the numeric axis scale controls found in desktop Excel. You can edit the source cells to update axis labels, or open the workbook in WPS Office Spreadsheets or desktop Excel to change the minimum value.
Why do my X-axis labels update when I edit cells in Excel Online?
Charts in Excel Online are linked to worksheet source data. When you change the source cells used for the axis labels, the chart refreshes and displays the new labels automatically.
How do I open an Excel Online workbook in WPS Office?
Download a copy of the workbook from Excel Online to your computer, then launch WPS Office Spreadsheets and use Menu > Open to select the file. Once open, right-click the chart axis and choose Format Axis.
Does changing X-axis values in WPS Office preserve my .xlsx file?
Yes. WPS Office Spreadsheets opens and saves .xlsx files with Microsoft Excel format compatibility, so your chart and workbook remain usable in Excel.




