Chart displays the date as number in the web version of Excel

Copper Contributor

I have a chart that I have copied and pasted from another workbook with the "keep source formatting" option in Excel desktop.


In the desktop version, the dates are displayed correctly, but in the Excel for Web version, they are displayed as numbers.


my regional format is fine in Excel for Web version


It's a problem because I use those charts on a SharePoint page and they are not displayed correctly.

3 Replies
After copying that chart, did you make sure its source data is in the workbook you pasted into?
they are in 2 different workbooks, but the link is there, every time we change some data, the chart changes dynamically.
I suspect this is an Excel on-line limitation. You'll have to manually format the axes (not make them use the source formatting) I think.