Hi
I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment)

I want the X axis to always display a month beyond the latest date, so
that the line graph stops short of the right hand side.

I can get the Y Axis of value to stay ahead of the game by a consistent
amount, but the date defaults back to the latest date when Auto for Max
value is ticked.

Is this possible? Will I have to use VBA?
Please clue me in.

Thanks
Dave F.