Chart & Visualization Issues

Fix Chart Dates Showing as Numbers in Excel for the Web

Elise WilliamsElise Williams Nov 13, 2026 869 views

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.

Fix Chart Dates Showing as Numbers in Excel for the Web
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the chart source data into 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.

2
Verify that the dates are real Excel dates

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.

3
Apply a date format to the chart axis

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.

4
Refresh or recreate the chart from the corrected data

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.

Copy the chart's source data and apply date formatting to the chart axis
Dates now appear correctly: After the source data and axis date format are corrected, the chart in Excel for the Web should display the expected date labels instead of serial numbers.
Free Microsoft Office alternative

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.

Opens and edits Microsoft Excel .xlsx files with full format compatibility.Maintains date-formatted source data and chart axis settings more consistently than copied web charts.Free, lightweight Office suite with a familiar ribbon interface and chart tools.Easy migration from Excel without losing workbook data or formatting.
microsoft office alternative - wps office

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.