Chart doesn't recognize date format
 

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

Chart doesn't recognize date format
 

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

Chart doesn't recognize date format
 

If even a single cell in the range of X values is text instead of a
date, Excel will not treat the axis as a set of dates.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/4/2010 5:15 PM, 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

Chart doesn't recognize date format
 

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