Chart & Visualization Issues

Show Repeated Zero X-Axis Values in an Excel Chart

Anum MushtaqAnum Mushtaq Nov 20, 2026 868 views

Question details

The user wants repeated zero X-values to appear separately in a chart without removing valid data.

Show Repeated Zero X-Axis Values in an Excel Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Insert a line chart

Select the measurement values, such as the VO2 column, then choose Insert > Line or Area Chart > Line.

2
Set the X-axis labels

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.

3
Check the series

In Select Data, verify that the measurement column is the plotted series and that the axis-label range includes every corresponding row. Click OK.

4
Confirm the axis type

If repeated labels do not appear as expected, right-click the horizontal axis, choose Format Axis, and set Axis Type to Text axis.

Use an Excel line chart to show repeated values as categories
Category spacing: A line chart shows rows in order but does not preserve proportional numeric spacing between X-values.
Chart data in WPS Spreadsheet

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. 1. Open the spreadsheet: Open WPS Spreadsheet and use File > Open to select your Excel workbook.
  2. 2. Create a line chart: Select the measurement values, then choose Insert > Chart and select a Line chart.
  3. 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. 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.
Show repeated zero values as separate chart categoriesOpen and edit Microsoft Excel XLS and XLSX filesCreate charts using a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.