I have data that is encompases less than 2 days but there are many points of
reference during the day. I am set for the Y axis but I can only get the X
axis to take the direct data and spread it throughout the day (showing equal
intervals between the data points rather than through the time points). I
would like to break up the day at intervals of 5 or 10 minutes and have the
data points position themselves throughout the 5 or 10 minute tick marks:

For example

Y X X-axis
tick
Date July 14,2005 45 23:45 (hr:mm) around 24:00
July 14 60 23:50 around 24:00
but not same as above
July 15 40 01:00 a bit past
24:00

Right now it spreads all the date all over the axis rather than bunching up
several plot points together in a 5-10 minute time interval.

Dianne -

I answered your other post. The answer: use an XY chart. More details in your other
post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Dianne wrote:

> I have data that is encompases less than 2 days but there are many points of
> reference during the day. I am set for the Y axis but I can only get the X
> axis to take the direct data and spread it throughout the day (showing equal
> intervals between the data points rather than through the time points). I
> would like to break up the day at intervals of 5 or 10 minutes and have the
> data points position themselves throughout the 5 or 10 minute tick marks:
>
> For example
>
> Y X X-axis
> tick
> Date July 14,2005 45 23:45 (hr:mm) around 24:00
> July 14 60 23:50 around 24:00
> but not same as above
> July 15 40 01:00 a bit past
> 24:00
>
> Right now it spreads all the date all over the axis rather than bunching up
> several plot points together in a 5-10 minute time interval.

"Dianne" <(E-Mail Removed)> wrote in message
news:728F2CFD-7177-4618-8AA6-(E-Mail Removed)...
>I have data that is encompases less than 2 days but there are many points
>of
> reference during the day. I am set for the Y axis but I can only get the
> X
> axis to take the direct data and spread it throughout the day (showing
> equal
> intervals between the data points rather than through the time points). I
> would like to break up the day at intervals of 5 or 10 minutes and have
> the
> data points position themselves throughout the 5 or 10 minute tick marks:
>
> For example
>
> Y X X-axis
> tick
> Date July 14,2005 45 23:45 (hr:mm) around 24:00
> July 14 60 23:50 around 24:00
> but not same as above
> July 15 40 01:00 a bit past
> 24:00
>
> Right now it spreads all the date all over the axis rather than bunching
> up
> several plot points together in a 5-10 minute time interval.

What sort of chart are you using? Make sure it's XY (Scatter).
--
David Biddulph