Date & Time on X Axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You should have your date and time in the same cell. Your choices for
plotting are to make a Line chart, and make sure the axis is category (Chart
menu > Chart Options > Axes tab), so each date/time has a unique slot on the
category axis, or to make an XY chart, so date/time is a continuous variable
across the X axis.

- Jon
 
thanks Jon

but my next problem of is there a easy calculation that will add one minute
to a cell that reads "24/08/06 12:55" so that i can carry a time calculation
through to "27/08/06 13:27"

Gary
 
Put the first date-time in cell A2, then in A3 use this formula:

=A2+TIME(0,1,0)

and drag it down the column.

- Jon
 
Thanks Jon

Is there any way to scale the axis in 6 or 12 hour periods as excel is only
letting me use a 1 day/week or month scale.

Gary
 
Make an XY chart, not a line chart. You should have very flexible control
over this scale. Use 0.25 for 6 hours or 0.5 for 12 hours.

- Jon
 
Back
Top