Hay Jon,

Don't you have anything better to do on a Friday night? My excuse is I'm
married. Speaking of marriage, Marsha, who I think you met at the last
Summit, is waiting for the next one, she likes the parties, and dinners out.

--
Cheers,
Shane Devenshire


"Jon Peltier" wrote:

I doubt the version has anything to do with it. Excel 97 and Excel 2003 are
much more alike than Excel 2003 and Excel 2007, and in any case, my initial
response is the same.

I suspect that the added cell is not a true numerical date, but text that
appears as a date to us humans, and which Excel interprets as text. This
prevents Excel from properly treating the cell as a date.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
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!!!