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" <(E-Mail Removed)> wrote in message
news:48576198-DBAE-47DC-8B17-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:48576198-DBAE-47DC-8B17-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:1F0B008F-02EE-4C28-B132-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:48576198-DBAE-47DC-8B17-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
> news:1F0B008F-02EE-4C28-B132-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:48576198-DBAE-47DC-8B17-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
news:75A4F775-E7A7-4B87-97C3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:1F0B008F-02EE-4C28-B132-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:48576198-DBAE-47DC-8B17-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>