How to Show All X-Axis Date Labels in WPS Office Spreadsheets
Question details
The user wants a WPS Office Spreadsheets chart to display every date label on the horizontal axis, including the final date labels that are currently missing.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Editing or reviewing a chart whose horizontal axis should show the complete date range from the source data.
- Observed behavior
- The chart does not show the final date labels because the axis is using an automatic maximum bound or an incorrect axis type.
Open the WPS Office Spreadsheets workbook that contains the chart, and check that the chart’s source data range includes all date cells with no blank or hidden cells before you change the axis settings.
Set the Horizontal Axis Type to Text Axis
Use this method when each date in the source data should be treated as a category and you want every date label shown exactly as entered.
Double-click the horizontal axis of the chart to open the Format Axis pane on the right side of the WPS Office Spreadsheets window.
In the Format Axis pane, expand Axis Options and locate the Axis Type section.
Choose Text axis to treat each date as a category so all source dates, including the final label, appear on the horizontal axis.
Use Date Axis and Set the Correct Minimum and Maximum Bounds
Use this method when the horizontal axis must remain a date/time axis and you want to manually extend the visible range to include the final date.
Verify the Chart Source Data Range
Use this method to rule out missing, hidden, or blank date cells before changing axis format settings.
Show Every X-Axis Date Label in WPS Office Spreadsheets Charts
Use WPS Office Spreadsheets to control chart axis types and bounds so all date labels, including the final date, appear correctly.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, open the Excel workbook, and select the chart with the missing date labels.
- 2. Open Format Axis: Double-click the horizontal axis to open the Format Axis pane.
- 3. Set the axis type or bounds: Choose Text axis or set the Maximum bound to include the final date.
- 4. Save the workbook: Save the file in .xlsx format to preserve the chart settings and Excel compatibility.
Frequently Asked Questions
Why does my Excel chart not show the last date on the x-axis?
Usually the axis Maximum bound is not set to Auto, or the axis is using a Date axis with a bound earlier than the last date. Double-click the x-axis, open Format Axis > Axis Options, and set Maximum to Auto or choose Text axis.
How do I make every date appear as a category label in WPS Office Spreadsheets?
Double-click the horizontal axis, expand Axis Options, and select Text axis. This treats each date as a separate category instead of spacing it by date value.
Can I set a specific date as the x-axis maximum?
Yes. In Format Axis > Axis Options > Bounds, type a date equal to or later than your last data point in the Maximum field, then press Enter.
Will changing the axis type affect my existing Excel chart data?
No. It changes label spacing but does not alter the source data. In WPS Office Spreadsheets, you can switch back to Date axis anytime in Format Axis > Axis Options.
Why are some date labels still hidden after changing the axis bounds?
Check the Select Data range to ensure all date cells are included and not hidden or blank. Right-click the chart and choose Select Data to verify the category range.
