Show Repeated Zero X-Axis Values in an Excel Chart
Question details
The user wants repeated zero X-values to appear separately in a chart without removing valid data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Plot measurements against X-values such as 0, 0, 50, and 100 while preserving every data point.
- Observed behavior
- An XY scatter chart places repeated X-values at the same horizontal coordinate rather than treating them as separate categories.
Identify the column containing the X-values and the column containing the measurements to plot. Check whether the zeros are valid observations and decide whether you need a numeric X-axis or equally spaced categories.
Use an Excel line chart to show repeated values as categories
Use a line chart when each row should appear in sequence, including repeated zero labels.
A line chart uses a category axis, so repeated labels can occupy separate positions. The positions are equally spaced and do not represent the numeric distance between X-values.
Select the measurement values, such as the VO2 column, then choose Insert > Line or Area Chart > Line.
Right-click the chart and choose Select Data. Under Horizontal (Category) Axis Labels, click Edit and select the X-value cells, such as the Power column.
In Select Data, verify that the measurement column is the plotted series and that the axis-label range includes every corresponding row. Click OK.
If repeated labels do not appear as expected, right-click the horizontal axis, choose Format Axis, and set Axis Type to Text axis.

Keep the Excel scatter chart for a numeric X-axis
Use this option when the horizontal position must reflect the actual X-value.
Show repeated X-axis labels in WPS Spreadsheet
Create a line chart in WPS Spreadsheet and use your X-value column as category labels to display repeated zeros in row order.
- 1. Open the spreadsheet: Open WPS Spreadsheet and use File > Open to select your Excel workbook.
- 2. Create a line chart: Select the measurement values, then choose Insert > Chart and select a Line chart.
- 3. Assign category labels: Select the chart and open Select Data from the chart tools. Set the horizontal axis labels to the cells containing the X-values.
- 4. Verify the data: In the chart data settings, check that the measurement series and axis-label ranges include all corresponding rows, including rows with zero X-values.

Frequently Asked Questions
Why do repeated zeros share one position in my scatter chart?
An XY scatter chart uses a continuous numeric X-axis, so every X-value of 0 has the same horizontal coordinate. Different Y-values can still place those points at different heights.
Can a scatter chart show repeated X-values as separate categories?
Not on its numeric X-axis: equal X-values must share a horizontal position. Use Insert > Line or Area Chart > Line and assign the X-value cells as category labels if separate positions are more important than numeric spacing.
Should I delete zero values to make the chart easier to read?
Do not delete valid zeros. Removing them changes the data and can remove legitimate points. Check the source cells and correct zeros only if they are data-entry errors.
How do I set the Power column as labels in Excel?
Right-click the line chart, choose Select Data, and click Edit under Horizontal (Category) Axis Labels. Select the Power cells corresponding to the plotted measurements, then click OK.




