How to Fix Blank Space on an Excel Chart with Two Y-Axes in WPS Office
Question details
The user needs to eliminate an unwanted blank space at the right side of a WPS Office Excel chart that has two Y-axes. The chart includes an XY Scatter series, which makes the X-axis behave as a continuous numeric scale and includes unused values.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user is building or editing a two Y-axis chart in WPS Office Spreadsheet and wants the secondary Y-axis to align correctly with the maximum X-axis value.
- Observed behavior
- The secondary Y-axis does not align with the maximum X-axis value, and the chart shows extra blank space because the XY Scatter series extends the numeric X-axis range.
Open the affected WPS Office workbook and select the chart. Identify the series that is currently plotted as an XY Scatter type and note whether it is assigned to the primary or secondary Y-axis.
Convert the XY Scatter Series to a Line Chart and Keep Markers Visible
Use this method when an XY Scatter series makes the X-axis continuous and creates blank space; changing the series to a Line chart aligns the axis while preserving data markers.
WPS Office treats an XY Scatter series as numeric data on the X-axis, so unused numeric positions can remain in the chart scale. Converting that series to a Line chart changes the X-axis treatment so the chart no longer reserves space for unused numeric values.
After the conversion, disable the connecting line if you want the series to look like a scatter series with only markers.
In WPS Office Spreadsheet, click the chart to select it, then right-click the affected XY Scatter series and choose Change Series Chart Type.
In the Chart Type dialog, select the affected series and change its chart type from XY Scatter to Line. Click OK to apply the change.
Right-click the converted series, choose Format Data Series, go to Fill & Line, expand Line, and select No line so only the markers remain visible.
Click the chart and look at the X-axis. The blank space should be removed, and the secondary Y-axis should now align with the maximum X value. Save the workbook to keep the change.
Manually Set the Horizontal Axis Maximum as a Temporary Alternative
Use this if you cannot change the series type or need to keep the XY Scatter series; set the axis maximum so the chart stops showing unused numeric space.
Fix Two-Axis Chart Blank Space Directly in WPS Office Spreadsheet
WPS Office Spreadsheet lets you edit the chart series type, format axes, and remove connecting lines directly in the same workbook. You can keep your Excel-compatible workbook structure and fix the chart without switching tools.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office Spreadsheet and open the affected .xlsx workbook containing the two Y-axis chart.
- 2. Select the chart and right-click the XY Scatter series: Click the chart to select it, then right-click the series that is plotted as XY Scatter and choose Change Series Chart Type.
- 3. Change the series to Line and remove the line: In the Chart Type dialog, set the series to Line, click OK, then use Format Data Series > Fill & Line > Line > No line to keep markers only.
- 4. Check the axis alignment and save: Verify that the blank space is gone and the secondary Y-axis aligns with the maximum X value, then save the workbook in WPS Office compatible format.
Frequently Asked Questions
Why does my two Y-axis chart have a blank area on the right?
Because an XY Scatter series treats the X-axis as a continuous numeric scale, WPS Office can include unused numeric values in the axis range. Convert that series to a Line chart to remove the extra space.
How do I change an XY Scatter series to a Line chart in WPS Office?
Select the chart, right-click the XY Scatter series, choose Change Series Chart Type, and change that series from XY Scatter to Line.
Can I keep the marker-only look after converting to a Line chart?
Yes. Right-click the converted series, open Format Data Series, go to Fill & Line, expand Line, and select No line. The markers remain visible.
Will manually setting the X-axis maximum fix the blank space if I keep the scatter series?
It can reduce the blank space temporarily. Right-click the horizontal axis, open Format Axis, and set Maximum to Fixed with your actual maximum X value, but it may need updating when data changes.
Does this affect the secondary Y-axis?
Yes. After changing the XY Scatter series to a Line chart, the secondary Y-axis no longer expands to the unused numeric X range, so it aligns with the intended maximum X value.
