How to Move the Excel X-Axis from 0 to 1 in WPS Spreadsheet
Question details
The user needs to adjust a line chart in WPS Spreadsheet so the horizontal category axis labels begin at 1 instead of 0 and the final label appears as 70.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- A line chart's category axis currently starts at position 0, but the user wants the first nest labeled 1 and the final nest labeled 70.
- Observed behavior
- The horizontal axis currently starts at 0, so the category labels and data points are not aligned to the desired 1-70 sequence.
Open the workbook in WPS Spreadsheet and select the line chart. Confirm that you can see the horizontal category axis and can right-click it to access Format Axis.
Change Axis Position to Between Tick Marks
Use this solution when the line chart’s category labels start at 0 and you want the first label to read 1 and the last label to read 70.
A line chart normally places category labels on tick marks. Moving the axis position to Between tick marks shifts the category labels so the first nest aligns with the chart’s first data point, which changes the visual start from 0 to 1.
Click the line chart in your WPS Spreadsheet worksheet to activate the chart tools.
Right-click the horizontal X-axis and choose Format Axis. Alternatively, double-click the X-axis to open the pane.
In the Format Axis pane, expand Axis Options and find the Axis Position setting.
Change Axis Position from On tick marks to Between tick marks.
Close or keep the pane open and check that the first label is now 1 and the final label is 70.
Adjust a Line Chart X-Axis in WPS Spreadsheet
Use WPS Spreadsheet's Format Axis pane to set the category axis position to Between tick marks. This moves the horizontal labels from a 0-start alignment to the 1–70 sequence without recreating the chart, and keeps your Excel-compatible files fully editable.
- 1. Open your workbook: Launch WPS Spreadsheet and open the Excel-compatible .xlsx workbook that contains the line chart.
- 2. Select the X-axis: Click the chart, then right-click the horizontal axis and choose Format Axis.
- 3. Change Axis Position: In Format Axis > Axis Options, set Axis Position to Between tick marks.
- 4. Save the file: Confirm the labels shifted and save the workbook in WPS Spreadsheet or save as .xlsx.
Frequently Asked Questions
Why does my line chart X-axis start at 0 instead of 1?
WPS Spreadsheet category axes often place labels on tick marks, which can show the first label at 0. Changing Axis Position to Between tick marks moves the labels to the desired 1–70 sequence.
Where is Axis Position in WPS Spreadsheet?
Select the X-axis, right-click and choose Format Axis, then expand Axis Options. The Axis Position setting appears under the axis options.
Will changing Axis Position affect my data values?
No. It only changes how category labels align with data points; the underlying plotted values remain unchanged.
Can I use the same fix for a column chart?
The Axis Position option is available for category axes in many WPS charts, but the effect is most visible in line charts. Select the axis and check if Between tick marks works for your chart type.
How do I make the value axis start at 1 instead of 0?
If the X-axis is a numeric value axis, select it, open Format Axis, and set Axis Options > Bounds > Minimum to 1. For a category axis, use the Between tick marks setting described above.
