In EXCEL 2007 there is also a Help topic called:-

Display dates on a category axis

Do a search on the above for a fuller explanation.

If my comments have helped please hit Yes.

Thanks.



"gkr" wrote:

How do I scale a time-scale axis using the conventional date format instead
of a date in the mysterious long string of numbers that randomly shows up for
the dates? Why does this change from chart to chart (sometimes conventional
date formatting, sometimes the string of numbers) and how do I change it or
prevent it from being that way in the first place?