Make Excel Chart Date Labels Use a Consistent Format in WPS Office
Question details
The user needs to make Excel chart date labels display in a consistent dd/mm/yy format when two chart series use the same data logger timestamps but show inconsistent date formats.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a chart that has two series based on the same data logger timestamps and wants the axis labels to use one consistent date format.
- Observed behavior
- One chart series displays dates in dd/mm/yy format while the other series displays dates inconsistently, likely because of source-cell or axis formatting.
Open the workbook in WPS Office Spreadsheets and confirm that the date cells are stored as real date-time values rather than text. Select the chart and note which axis shows the inconsistent labels before applying a format.
Format Source Date Cells to dd/mm/yy and Apply the Same Number Format to the Chart Axis
Use this when both chart series use identical timestamps but the axis labels are inconsistent; it aligns the chart axis with the worksheet date cell format.
Inconsistent date labels typically appear because the chart axis uses a number format that differs from the source cells, or because one series is stored as text. Formatting the cells first and then setting the axis number format ensures the chart displays dates uniformly.
Open your workbook in WPS Office Spreadsheets and select the worksheet cells that contain the data logger timestamps used by both chart series.
Right-click the selected cells, choose Format Cells, click the Number tab, select Date or Custom, and enter dd/mm/yy or choose the matching regional date format.
Click the chart axis that shows inconsistent date labels, right-click it, and choose Format Axis from the context menu.
In the Format Axis pane, expand Axis Options or Number, select the same date format as the cells, and enable Link to source if available so the axis follows the worksheet formatting.
Check that both chart series now show dates in dd/mm/yy; if not, confirm that the source data is recognized as a date and not as text.
Confirm Both Series Use Real Date-Time Values Instead of Text
Use this if formatting the axis alone does not fix the inconsistent labels; it checks and converts text timestamps to true date-time values.
Fix Inconsistent Excel Chart Date Labels in WPS Office Spreadsheets
Open the workbook in WPS Office Spreadsheets, format the timestamp cells to dd/mm/yy, and use Format Axis to apply the same date format. This keeps both chart series displaying consistent dates without needing another Office suite.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, click Open, and select the Excel workbook containing the chart with inconsistent date labels.
- 2. Format the timestamp cells: Select the date cells, right-click, choose Format Cells, and set the Number type to Date or Custom with dd/mm/yy.
- 3. Open Format Axis: Click the chart axis, right-click, and choose Format Axis; in the pane select the same dd/mm/yy format or enable Link to source.
- 4. Check both series: Confirm both series now show consistent dates; if a series is text, convert it to real date values and refresh the chart.
- 5. Save in Excel format: Press Ctrl+S or click Save and keep the workbook as .xlsx so it remains compatible with Microsoft Excel.
Frequently Asked Questions
Why does my Excel chart show different date formats for two series with the same timestamps?
Usually the chart axis number format differs from the source cells, or one series contains text-based timestamps. In WPS Office Spreadsheets, format the source date cells as dd/mm/yy and then set the axis number format to match.
How do I apply dd/mm/yy to a chart axis in WPS Office?
Right-click the axis, choose Format Axis, expand Axis Options or Number, and select the same date format as the source cells. Enable Link to source if available.
What if one series still does not display dates correctly after formatting the axis?
Check whether the source data is stored as true date-time values. Use the formula bar or Format Cells to identify text strings and convert them with DATEVALUE or Text to Columns, then refresh the chart.
Will these changes remain when I open the file in Microsoft Excel?
Yes. WPS Office saves the workbook as .xlsx, so the chart and date formats remain compatible with Microsoft Excel.
Can I link the chart axis to source cell formatting in WPS Office?
Yes, in the Format Axis pane you can enable the option to link the number format to source data, depending on the chart type, to keep axis labels consistent with the worksheet.
