Date display issue in XY scatter

[mcamilleri]

I have a problem with the way dates are being displayed in the x-axis of an XY scatter.

The x-axis data is being read from a column with Date (dd/mm/yyyy (English UK)) format using =Data!$A$2:$A$803. The dates in the column start at 24/10/2008 up to 28/10/2011. The dates in the plot read 00/01/1900 to 18/06/1902. The format of the x-axis is also dd/mm/yyyy (English UK). What could be wrong?

 

[Andrew Poulsom]

Welcome to MrExcel.

That's because your dates are text entries that look like dates rather than serial dates. You can convert them by choosing Data|Text To Columns and clicking Finish.

Note that formatting a cell only changes its appearance, not what it contains. The x axis has defaulted to 0 to 900 in the absence of any real values.

 

[mcamilleri]

Brilliant! Thanks a lot Andrew!