y axis based on a 24 hour clock

  • Thread starter Thread starter diane
  • Start date Start date
D

diane

Is it possible to chart data in 2000 with the x axis as
date and the y axis based on a 24 clock? The user wants
to start at say 0800 in the morning and finish at 2400.

Thanks in advance
 
Diane -

You can certainly use date as one axis and time of day as the other, in
whatever format you like. What are you charting, in what kind of chart?

- Jon
 
I have dates along the x axis and time along the y axis.
The problem is with the time axis(y). I want the graph to
show from 10pm to 3 am, but the axis always starts from
midnight and goes up to 23:59. Time in excel seems to be
stored as a number from 0 to 0.9999 where 0 is midnight
and 0.999ish is 23:59.

To sumerise the line graph y axis curretly show this

00:00
20:00
16:00
12:00
08:00
04:00
00:00

and I want to show it as

04:00
02:00
00:00
22:00

Your help would be much appreciated.

Thanks in advance.
 
Double-click the y-axis and in the resulting dialog box, select the
Scale tab. In the Min and Max fields specify the values you want.
Specify the time as you normal would, i.e, 9:00 or 21:00 (my computer
is set to a 24 hour clock).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Format the time cells using the custom number format [h]:mm, which keeps
counting hours beyond midnight. Enter your data as times since midnight
prior to the 10 pm shift start, so 10 pm is 22:00 and 3 am is 27:00. So
the data looks like this:

Time
11/28/2003 25:30
11/29/2003 26:00
11/30/2003 24:00
12/1/2003 23:00
12/2/2003 22:45
12/3/2003 22:30
12/4/2003 23:15

In the chart, format the Y axis with the same custom number format. Set
the minimum to 22:00 and the max to 27:00.

- Jon
 
Back
Top