Forum Discussion
belilan5770
Sep 06, 2023Copper Contributor
Chart displays the date as number in the web version of Excel
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 ...
belilan5770
Sep 06, 2023Copper Contributor
they are in 2 different workbooks, but the link is there, every time we change some data, the chart changes dynamically.
JKPieterse
Sep 07, 2023Silver Contributor
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.