The version is Excel 2007.

Yes the data has underlying date format.

Thanks

Doug


"trip_to_tokyo" wrote:

Which version of EXCEL?

Has you underlying data got a Date format?



"dbasmb" wrote:

I've had this problem many times and cannot figure out why it happens some
times.

I insert a chart with my data highlighted including one column that has a
date format. It charts the data OK but if I go to format the x - axis,
sometimes it will give me axis options having to do with dates (eg major unit
fixed at one month) as I want but other times it gives me a completely
different window of axis options that does not include the date functions.
The window shows 'Interval between ticks:' and 'Interval between labels:'
etc. but nothing indicating that it is a date function, even if I check the
Axis Type to be date. Many times it won't even display my date format choice
that I make on the 'Number' option window. This makes the formating of the
date on the x-axis not clean since I cannot choose the intervals to be date
friendly.

What's going on??

Thanks in advance!

Doug