Chart & Visualization Issues

How to Change the X-Axis Values in Excel Online: Workaround and WPS Fix

Rana GarciaRana Garcia Nov 13, 2026 868 views

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.

How to Change the X-Axis Values in Excel Online: Workaround and WPS Fix
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the chart in 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.

2
Edit the X-axis source cells

Click the worksheet cells that contain the current X-axis labels or values, type the new values or labels, and press Enter.

3
Confirm the chart refresh

Check the chart after editing. Excel Online updates the horizontal axis automatically from the edited source cells.

Numeric scale controls still require a desktop app: Changing the X-axis minimum, maximum, or number format is not available directly in Excel Online. Use desktop Excel or WPS Office Spreadsheets for those settings.
WPS Spreadsheets

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. 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. 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. 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. 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.
Full Format Axis controls for chart minimum, maximum, and label settingsOpens and saves .xlsx files with Microsoft Excel format compatibilityFree, lightweight Office suite with a familiar ribbon interfaceNo need to switch between Excel Online and desktop Excel
microsoft office alternative - wps office

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.