chart axis formatting change

[[email protected]]

In Excel 97 I could take the following data and make a line chart that
would allow me to format the x-axis as date and time and be able to
space out the text enough to read it. With the change over to Excel
2000+ this has changed and it no longer works; the scale option on
format axis is greyed out. For a while I was able to do a x-y scatter
chart and get it to work that way. Apparently one of the automatic
updates has fouled that up. Is there a way to get the charts to print
date and time on the x-axis and still be able to format the scale so
it's readable?

Date Time A B C D E LS
US
6/25/2006 22:00:00 67.95 68.05 68 68.55 68.05 67 69
6/25/2006 23:00:00 67.95 68.1 68.05 68.45 68 67 69
6/26/2006 0:00:00 67.95 68.1 67.95 68.35 67.85 67 69



Failing that, is there a way to get Excel 97 to run properly on XP?

[Bernard Liengme]

I had not trouble making a Line chart of your data in XL 2003. The Date and
Time showed up a on the axis one over the other (wrapped text). But I must
point out that I did a copy form the email to Excel and since I use Canadian
date format, all your date column was treated as text.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<[email protected]> wrote in message
news:[email protected]...
> In Excel 97 I could take the following data and make a line chart that
> would allow me to format the x-axis as date and time and be able to
> space out the text enough to read it. With the change over to Excel
> 2000+ this has changed and it no longer works; the scale option on
> format axis is greyed out. For a while I was able to do a x-y scatter
> chart and get it to work that way. Apparently one of the automatic
> updates has fouled that up. Is there a way to get the charts to print
> date and time on the x-axis and still be able to format the scale so
> it's readable?
>
> Date Time A B C D E LS
> US
> 6/25/2006 22:00:00 67.95 68.05 68 68.55 68.05 67 69
> 6/25/2006 23:00:00 67.95 68.1 68.05 68.45 68 67 69
> 6/26/2006 0:00:00 67.95 68.1 67.95 68.35 67.85 67 69
>
>
>
> Failing that, is there a way to get Excel 97 to run properly on XP?
>

[[email protected]]

It will make a chart showing the date for a few rows as I have
included. The more rows you add the more compacted the text becomes and
it is soon unreadable. The format axis/scale selection is greyed out
and unusable. Some of my charts cover several thousand rows so this
function is a must for intelligible data. What I need is an alternative
now that both the line chart and the x-y chart won't handle the data
properly.









Bernard Liengme wrote:
> I had not trouble making a Line chart of your data in XL 2003. The Date and
> Time showed up a on the axis one over the other (wrapped text). But I must
> point out that I did a copy form the email to Excel and since I use Canadian
> date format, all your date column was treated as text.
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
> >
> > Date Time A B C D E LS
> > US
> > 6/25/2006 22:00:00 67.95 68.05 68 68.55 68.05 67 69
> > 6/25/2006 23:00:00 67.95 68.1 68.05 68.45 68 67 69
> > 6/26/2006 0:00:00 67.95 68.1 67.95 68.35 67.85 67 69
> >
> >
> >
> > Failing that, is there a way to get Excel 97 to run properly on XP?
> >