How to Remove Missing Numbers from an XY Scatter Chart Axis in WPS Spreadsheets
Question details
The user wants to remove intermediate numeric labels from the horizontal axis of an XY scatter chart when the chart only contains discrete X values such as 1 and 7.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Creating or editing an XY Scatter chart in WPS Spreadsheets where the X values are discrete numbers, but the chart axis displays intermediate values with no corresponding data points.
- Observed behavior
- The XY Scatter chart shows missing intermediate numbers such as 2, 3, 4, 5, and 6 on the horizontal axis even though those X values do not exist in the data.
Open the workbook in WPS Office Spreadsheets, select the chart, and right-click the horizontal axis to confirm whether it is set as a numeric value axis. This helps you decide between changing the chart type and formatting the axis scale.
Switch to a Line Chart with a Text Category Axis
Use this solution when you want the horizontal axis to show only the X values that exist in your data instead of evenly spaced numeric intervals.
An XY Scatter chart always uses a continuous numeric value axis. A Line chart can use a text category axis, so it displays the exact labels from your worksheet instead of filling in missing numbers.
In WPS Spreadsheets, click the chart to select it, then go to Chart Tools > Change Chart Type.
In the Change Chart Type dialog, select Line and choose Line with Markers, then click OK.
Right-click the horizontal axis, choose Format Axis, expand Axis Options, and select Text axis if the option is available.
Format the Scatter Chart Axis Scale to Control Displayed Numbers
Use this method if you must keep the XY Scatter chart and only want to reduce or control the intermediate axis labels.
Show Only Existing X-Axis Labels in WPS Spreadsheets Charts
Open your Excel XY scatter workbook in WPS Office Spreadsheets and switch the chart to a line type with a text category axis, or set a custom axis scale, so the axis labels match your actual data. WPS keeps your XLSX charts and formatting intact while giving you a free, familiar spreadsheet editor.
- 1. Open the Excel file in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the workbook that contains the XY scatter chart.
- 2. Select the chart and open Change Chart Type: Click the chart, go to Chart Tools > Change Chart Type, and choose Line with Markers.
- 3. Configure the horizontal axis as Text: Right-click the horizontal axis, select Format Axis, and in Axis Options choose Text axis so only your supplied X labels appear.
- 4. Or adjust the scatter axis scale: If you keep the XY Scatter chart, right-click the value axis, choose Format Axis, and set Minimum, Maximum, and Major unit to the exact tick values you want.
Frequently Asked Questions
Why does my XY scatter chart show numbers that are not in my data?
An XY Scatter chart uses a continuous numeric value axis. Excel and WPS Spreadsheets display regular intervals between the minimum and maximum X values, even if some intermediate numbers do not exist in the data.
Can I make an XY scatter chart use a text axis?
No, the X-axis of an XY Scatter chart is always numeric. To display only the existing text-like category labels, change the chart to a Line chart and set the horizontal axis to Text axis.
How do I change a scatter chart to a line chart in WPS Spreadsheets?
Select the chart, go to Chart Tools > Change Chart Type, choose Line, and select Line with Markers. Then right-click the horizontal axis and use Format Axis to select Text axis if needed.
Will changing the axis minimum and maximum remove intermediate labels?
It can reduce the number of displayed labels, but it does not make a scatter chart behave like a category axis. For exact labels only, use a Line chart with a text category axis.
Does WPS Spreadsheets support editing Excel XY scatter charts?
Yes, WPS Spreadsheets can open and edit Excel XLSX workbooks and charts, including XY Scatter charts, while preserving chart data and formatting.
