This is how I would do it
Open the x-axis format dialog and open first tab 'Axis Options'
In the first two items set the smallest and highest x-axis label value
Type in a 2010 date as needed
Is this what you tried?
Do you have a Line or an XY chart?
Excel 2007 had problems with setting limits in an XY chart when the values
are dates.
Here is the workaround: type the required date into a cell on the worksheet
(say 31-dec-2010)
Now format that cell General to get the date serial number (40543)
Enter this 5 digit number into the box in the axis format dialog rather than
an actual date
The problem is fixed in Excel 2010 beta
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jim26" wrote in message
...
I have a line graph of accounts on the Y-axis, plotted against months on
the
x-axis.
I extended the axis for 2008 (in Excel 2000), I now want to extend it
again
for 2010, but I am having trouble.