Time on Y-Axis

[Mary]

I am trying to plot a graph with the time on the y-axis and days on the
x-axis..

The chart is suppose to plot the trends of when a process is completed -
this process includes 4 specific items. There are 4 daily tasks that are to
be completed daily and I want to be able to plot this completion time in a
chart so that the trends of when each item is usually completed can be noted.

Another problem with this graph is that one item is completed the night
before at 9PM but counts towards the next day's process and should actually
be counted as the "start" of the items being processed. (i.e. I want the 9PM
time from the previous day to appear at the bottom of the graph, and the
later 3 process times to appear above the "start" time)

Currently, the y-axis of my graph starts at 12:00AM and goes to 12:00AM and
goes to 4:48AM again (So the Y-axis actually spans over 24 hours..) Can you
please explain the logic behind how Excel chooses which "12:00AM" it uses to
plot the points.. and how I can change this y-axis to display times from the
previous nights and run into the day of the next day (i.e. 9PM from yesterday
to 9PM current day) and whether I will then have to adjust my data so that it
can be graphed at the appropriate 9PM (either yesterday or current day).

Thanks for your help!

 

[David Biddulph]

Remember that Excel counts time in multiples of a 24-hour day, so 9pm is
0.875. 9pm a day later is 1.875.
Recalculate from your data accordingly, and use those values as the limits
on your Y axis. (You can still format the values as times)

 

[Mary]

Thanks David.

I changed the axis so that it runs from 9pm to 9pm a day later.

However, I am now having problems with the data being plotted in the area
that I want it to be plotted.. the 9PM data will appear on the graph but the
data that is 2AM or 3AM the day later will not display on the graph since
that is in the "negative" values that is not within the range of the 24 hours
between 9PM and 9PM... How can I adjust my data so that it will be displayed?

 

[David Biddulph]

If you want to bring all your times within that range, why not
=MOD(A1-0.75,1)+0.75 (and format the result as time) ?