A Stacked bar chart should suffice:
Setup data as follows
Name Start End Duration (End - Start)
Fred 1/01/1981 1/06/1985 1612
Bill 1/07/1985 1/11/2000 5602
Joe 1/01/1980 1/12/2001 8005
Jim 1/03/1999 1/01/2000 306
- Plot
StartandDurationas a stacked bar chart - Set the
X-Axis minimumto the desired start date - Set the
FillColour of thestartrange tono fill - Set the
Fillof individual bars to suit
(example prepared in Excel 2010)
