Excel versions prior to Excel 2007 allowed dates to be entered as minimum
axis values for XY charts on the axis format scale menu. In Excel 2007 when
I attempt to enter a date as a minimum value, i.e. attempting to enter
1-1-2007 with the Fixed radio button selected in Axis Options, the automatic
value pops back up unchanged. I can successfuly enter a numeric value, but
not a date. This requirement adds several extra steps - calculating a date
value and typing the resulting number, then deleting the calculation - to
what used to be a simple process. If anyone knows that the same capability
still exists in Excel 2007 that I've just not found, please enlighten me.