A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chart doesn't recognize date format



 
 
Thread Tools Display Modes
  #1  
Old April 4th, 2010, 10:15 PM posted to microsoft.public.excel.charting
dbasmb
external usenet poster
 
Posts: 6
Default 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
  #2  
Old April 5th, 2010, 05:01 AM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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

  #3  
Old April 5th, 2010, 03:40 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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

  #4  
Old April 5th, 2010, 04:03 PM posted to microsoft.public.excel.charting
dbasmb
external usenet poster
 
Posts: 6
Default 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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.