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
-------
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

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

"Jon Peltier" wrote:

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

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


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

"Jon Peltier" wrote:

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

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

"Jon Peltier" wrote:

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


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

"Jon Peltier" wrote:

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

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


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

"Jon Peltier" wrote:

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


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

"Jon Peltier" wrote:

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