Excel - Changing scale on horizontal axis...

Asked By curvatur on 19-Dec-08 03:26 PM
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 replied on 20-Dec-08 10:20 AM
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
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.