Why Does Excel 2007 not allow the entry of a date in the Axis Opti

  • Thread starter Thread starter MarkG
  • Start date Start date
M

MarkG

I am attempting to enter a date to set the Min and/or Max value in the Axis
Options in a Line Chart. This is for the Vertical Axis.
When I enter a date ex 1/18/10 or 1/18/2010 in the Axis Options in a Line
Chart on the vertical axis, the value reverts to the original date code
40181.0 which is 1/3/10.
I used to be able to enter a date here and it would convert it. How Can I
get this to do it. Am I entering the information wrong.
My older version of excel (2002) I could even enter just the month and day
if I wanted the current year. ex 1/18 would have been sufficient and the
information was converted to the date number.

Does anyone know of a for sure fix yet??? SP2 did NOT fix this!
Thanks for any assistance!
Mark
 
This is a know bug. Workaround:
In a blank cell in worksheet enter the date you want to use as a scale limit
Format this General (you will get a 5-digit number like 40199)
Type this number in the Format Axis dialog

The good it is fixed in Excel 2010
best wishes
 
Back
Top