Chart copied to another workbook won't display horizontal axis in date format

1
votes

I'm trying to link a chart to another workbook in excel 2010. Copy-Paste does the trick, except for the dates on the horizontal axis. They keep showing as numbers (42515), but not in date format. I tried several things: change Axis type, convert source data to text (TEXT(42515; "dd/mm/yyyy")...

It's necessary that the link between the two charts stays, because I use it to automatically update the chart.

Anyone any suggestions?

1
excelchartsexcel-2010
Also, at least in Excel 2013 I cannot reproduce the problem. My chart is pasted into another workbook with the correct date formatting on the horizontal axis, and the values update once they are changed in the table in the first workbook. - ZygD
Too bad, Tnx anyway! - Nathalii.

1 Answers

0
votes

The Solution:

Right click on the Chart -> Format Axis -> Number -> Date