Time-Series Charting

[Guest]

I have 18 machines running during the course of the day. I would like to
create a chart with 1 - 18 on the y-axis and a horizontal bar or line
corresponding to the times during the day that the machine was active with
time (0:00 - 23:45) on the x-axis. I have the data for the time broken into
a "start time" column and and "stop time" column with the corresponding
machine number in a third column:

MACHINE START STOP
2 0:27 1:30
2 1:32 1:49
2 1:57 2:40
2 2:57 3:25
2 3:45 4:28
2 4:55 5:12
2 5:16 5:32
2 5:41 5:46

Thank you in advance for the help.

 

[Rob Hick]

I have 18 machines running during the course of the day. I would like to
create a chart with 1 - 18 on the y-axis and a horizontal bar or line
corresponding to the times during the day that the machine was active with
time (0:00 - 23:45) on the x-axis. I have the data for the time broken into
a "start time" column and and "stop time" column with the corresponding
machine number in a third column:

MACHINE START STOP
2 0:27 1:30
2 1:32 1:49
2 1:57 2:40
2 2:57 3:25
2 3:45 4:28
2 4:55 5:12
2 5:16 5:32
2 5:41 5:46

Thank you in advance for the help.

sounds like you're after a Gantt Chart. See the many many links at
http://peltiertech.com/Excel/Charts/GanttLinks.html for how to make one.

 

[F*SH]

Something like the Gantt Chart Rob mentioned is probably your best
charting option. Alternatively, if you like programming as much as I
do, you could make bars by colouring adjacent cells. Would take a wee
bit of code, but it would look good!

EDIT: Actually, I juist noticed you're looking for minute-level
resolution. Perhaps cells aren't the way to go. What I had in mind
works better when the day is broken down into hours.

 

[Guest]

Rob,

Thanks for the info

sounds like you're after a Gantt Chart. See the many many links at
http://peltiertech.com/Excel/Charts/GanttLinks.html for how to make one.