Prev: Chart.Name lives forever?
Next: trendline in scatter plot
From: dbasmb on 4 Apr 2010 17:15
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
From: trip_to_tokyo on 5 Apr 2010 00:01
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
From: Jon Peltier on 5 Apr 2010 10:40
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
From: dbasmb on 5 Apr 2010 11:03


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



 | 
Pages: 1
Prev: Chart.Name lives forever?
Next: trendline in scatter plot