Charting duration during one day?

[mrspeters]

I need to chart duration of a process for multiple threads during on
day. For this, I need hours of the day along the bottom (0 - 24) an
thread name on the left (vendor1, vendor2, vendor3, etc). I have star
time, end time, and duration for each of the threads, and need to sho
on the graph a line at the time of day the thread began, ending whe
the process for that thread ended; one line per thread. Make an
sense? Any ideas how to do this if it can be done at all ?

Example of how it needs to look

vendor1 | x------------------------------x
vendor2 |
x---------------x
vendor3 | x-------------------x
vendor4 |
x----------------------------------------------x
vendor5 | x---------x

 

[Jon Peltier]

Try a gantt chart:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttLinks.html

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