plotting person over time

Brass Contributor


I needed assitance with plotting a person (column a) over a course of time based on 1 st positive date (column b) and discharge date (column d). I have added an extra row that calculates the time in days between each date if that would help in plotting each persons length of time. I would want the x axis to have each persons name plotting out their time, and the Y axis would be the spawn of time, thank you  



1 Reply


Use a stacked bar chart with 1st Pos Date as first series and Time as second series, but make the bars of 1st Pos Date transparent.


See the attached workbook.