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.