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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"gamala" wrote in message
...
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