Tom,
I made a Line chart with dates in XL2007 and had no trouble entering a date
in the Maximum box.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"TomCon" wrote in message
news:Pb9Fh.6355$iF.1672@trndny03...
I am finding in 2007 that if i go to the "format axis" dialog, and for
"max" put a date, like "5/1/07", this will not format the axis with that as
the maximum. I have to [correctly] translate it to the serial number for
the date (in this case 39203) and enter that value into the dialog. In
previous versions, one could just enter the date in this dialog and the
chart axis was correctly formatted with the date value that you entered
directly into the dialog as the correct max for the axis [with no need to
translate to serial number for that date].

Is this a bug? Or is this the intended behavior? If so, why? Its a real
hassle to go back to the sheet and figure out what the correct serial
number should be in order to enter it into the dialog. Is there an option
or a way around this [extremely irritating] behavior?

Thank you. tom