need basic help setting up a graph

[dwh33]

Hello,

I am trying to set up a chart of days and times. The X- axis shoul
have the days of the week (mon, tues, etc) and the Y - axis should hav
various times of the day. I would like to have a line from on
specific time on one day to another specific time on the next. So,
point would be monday at 10:00 and the next would be tuesday at 1:00
followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo
your help

Davi

 

[Jazzer]

Hi David,

See my attachment. Is that the situation you explained?

I use formula

=IF(B2<0.5,B2+1,B2)

in column C to wrap the day to night.

- Asse

Attachment filename: daytimechart.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44884

 

[dwh33]

Thanks Jazzer,

How does the code work? I can plug it in so that my graph works,
but I don't understand how it is modifing the numbers. Thanks again!

David