A Gantt chart is need. Start by looking at
http://pubs.logicalexpressions.com/P...cle.asp?ID=343
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Tessa" wrote in message
...
I need to create a chart that lists 10 different employees' work periods
with
the company. They may overlap in some years. In one instance the
employee
worked from May 7, 1996 to Jul 12, 1999, and then again from Aug 4, 2001
to
Nov 11, 2008.