Changing scale on horizontal axis...

[curvature]

One of the many trying to replicate what I used to do in Excel 2003.

I want to change the "maximum" value on a horizontal "date" axis t o
extend my chart for another year. In 2003, right click on the axis-->
Format Axis--> change value in Maximum field--Bingo. In Excel 2007,
it ignores my attempts to change this value.

Running in compatibility mode.

 

[Jon Peltier]

Do you get the Format Axis dialog in 2007? Does the dialog provide places to
enter axis scale parameters? If not, you may have a category axis rather
than a date axis.

- Jon