Hi Mary,

We are now in 2008, Excel 97 came out in 1996, I don't expect many of us
have this version on our machines, there are just soooo..... many
enhancements since then.

But you can try something like this, I can't test for the reason mentioned
above, with the chart selected choose Chart, Chart Options, and click the
Axis tab and see if you can set the axis back to timescale.

No guarentees though...
--
Cheers,
Shane Devenshire


"Mary" wrote:

Hello,
I am using Excel 97. I updated a line chart by one cell. My x axis was
previously a Time (x) axis scale, showing ticks every 6 months: 1/00, 7/00,
1/01, etc. When I add one cell to the Source Data, Series, Category (x) axis
label (to match the additional one cell value in the Values box above it), it
throws my whole x axis off, changing it to every 3 months. When I double
click on this x axis, I then see the menu Category (x) axis scale, and cannot
get back to the Time (x) axis scale menu. How do I get back to the Time (x)
axis scale menu? Thank you in advance for helping me on a Friday afternoon!!!