Wrong dates in scatter chart

[hlm1249]

When I make a scatter chart of a column of dates versus a column of data values, the X axis doesn't show the actual dates. Instead, it shows 00-Jan-00, 02-Jan-00, etc.
However, if I make a column chart, the correct dates are displayed.
How can I fix this?

 

[Andrew Poulsom]

The only way I can reproduce that behaviour is by having the dates as text entries rather than serial dates.

 

[hlm1249]

The original data was imported from a 3rd party website.
The date column was reformatted as a date, but that gives the same result...

 

[hlm1249]

Let me give a clearer problem description.
You are right that the date column is being treated as text. But no matter what I do to reformat the cells to the date format, it keeps reverting back to text.

 

[Jon Peltier]

make sure the text at least looks like a date, and that the range is formatted as something numerical (not text). Then copy a blank cell, select the range of text dates, and from the Edit menu, use Paste Special, Values, Operation - Add.