date formatting problem: x axis

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

I have several chart files that are all the same except
for one that seems to go back to a formatting problem. I
can't remember how I fixed it last time, which was
temporary anyway. Problem is this:

I am using mostly end of year dates (12/31/94, 12/31/95,
etc.) However on my x axis it shows Dec-94, everytime I
try to reformat it to the correct format(xx/xx/xx), I get
12/01/94, 12/01/95, etc. Always the first day of the
month instead of the last.

I'm not having these problems with all the others similar
files. The only difference I have seen between the files
is the "Scale Tab" in the "Axis format" window.

Please help. Thanks, Janet
 
Hi Janet -

I assume you have a line chart with a time scale axis. Double click on
the axis, and click on the Scale tab. Set the minimum to 12/31/94 (or
whatever the first year-end is you're tracking), set the base unit to
days, and the major unit to 1 year.

- Jon
 
Back
Top