Help creating a chart
I am trying to create a timeline type of a chart (I think). Here is the scenario
I have six investigators. They are each in charge of 1 or more researchers who stay for any given length of time and researchers are categorized differently (i.e. fellow, associate, etc). I would like to create a chart that has the investigators on the Y axis and dates on the X axis. Each researcher's start and finished date should be shown in a color associated to research category (fellow, associate, etc). The line color coded to research category would extend from the start and finish dates and inline with one of the six investigators.