Forum Discussion
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 ...
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.
