View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jake Jake is offline
external usenet poster
 
Posts: 83
Default dates on scatter chart axis

In setting the scale (Minimum and Maximum under Axis Options) a scatter data
graph axis, in Excel 2003 you could enter the date (e.g., 1/1/1987) . In
Excel 2007 it appears I can only enter the number (e.g., 31778) which is
quite difficult.

Is there a way in Excel 2007 to enter the date?