Fix Chart Dates Showing as Numbers in Excel for the Web
Question details
The user needs to stop a chart in Excel for the Web from displaying serial numbers instead of dates after copying it from desktop Excel and restore the intended date labels on the chart axis.

- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- A chart copied from desktop Excel displays dates correctly in the original workbook but shows serial numbers in Excel for the Web, and the user wants the chart to display formatted dates.
- Observed behavior
- Excel for the Web displays date values as serial numbers on the chart axis even when the original desktop workbook shows dates correctly.
Open both the source desktop workbook and the destination Excel for the Web workbook. Check whether the chart's underlying source data was copied into the destination workbook, because a chart without its source data can lose date axis formatting.
Copy the chart's source data and apply date formatting to the chart axis
Use this when a copied chart shows serial numbers because Excel for the Web does not have the original date-formatted source data or compatible axis settings.
A chart pasted with source formatting may look correct initially but can lose date formatting when the underlying source data or number format is missing in the destination workbook.
Select the date column and the chart's value column in the original desktop workbook, press Ctrl+C, switch to the destination workbook in Excel for the Web, click the target cell, and press Ctrl+V to paste the source data.
Select the date cells, go to the Home tab, open the Number Format drop-down, and choose Short Date or Long Date instead of General or Number. The cells must behave as dates, not text or serial numbers.
Right-click the chart's date axis, choose Format Axis, expand Number, and select Date or set the same date format used in the source column.
If the chart still shows serial numbers, select the corrected data, go to the Insert tab, choose the same chart type, and insert a new chart. Then delete the old chart.

Save the workbook and confirm the updated SharePoint page
Use this when the chart is corrected in Excel for the Web but the SharePoint page still shows the older version.
Work locally in WPS Office to keep chart dates formatted correctly
If Excel for the Web keeps showing date serial numbers after copying or pasting charts, WPS Office provides a free, lightweight desktop alternative that opens Excel workbooks, preserves date and axis formatting, and gives you familiar chart tools for clean, reliable spreadsheets.

Frequently Asked Questions
Why does my Excel for the Web chart show serial numbers instead of dates after pasting it from desktop Excel?
It usually happens because the chart's underlying source data or date number format was not copied, so Excel for the Web treats the values as serial numbers. Check the pasted date column and format it as Short Date or Long Date, then update the chart axis.
How do I change the chart axis from serial numbers back to dates in Excel for the Web?
Right-click the date axis in the chart, choose Format Axis, expand Number, and select Date or the same date format used in your source column.
Do I need to copy the chart source data separately?
Yes. Placing only the chart may not bring the underlying source data. Select the source date and value columns in the original workbook, paste them into the destination workbook, then recreate or refresh the chart from that data.
What if the chart still shows numbers after I format the source cells?
Insert a new chart from the corrected data using Insert > Chart in Excel for the Web, or refresh the existing chart. If the workbook is embedded on SharePoint, save and refresh the SharePoint page as well.
Can I avoid this issue by opening the workbook in WPS Office?
Yes. WPS Office opens .xlsx files locally and preserves date-formatted chart axes more predictably, so you can edit the chart without the web copy issue.




