View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
gamala gamala is offline
external usenet poster
 
Posts: 3
Default Date & Time on X Axis

Hi I have a problem where i cannot get the date & time on the x axis. In
Excel 97 you used to be able to have the date in one cell and the time in the
next cell so that when a graph was created you would get a x axis with both
date and time showing on the major tick marks (ie 19/09/06 12:33), when you
try this on Excel 2003 you get a solid black line that i'm unable to read or
breakdown into sensible scale. Can anybody let me know how to solve this as
when you are looking at a weeks worth of data it is impossible to read any
type of date/time stamp.

Thans