Gantt Type Chart - with multiple items same line

[ejsdon]

Hi All,

I am attempting to display hire dates for some items - but I need to include mobilisation / demobilisation durations on the same line - and to display almost as a Gantt Chart.

I have attached an example of how I would like the finished sheet to look (kind of - I will make it look prettier), but manually entered the values and colours that I would like automated when I enter the dates in the appropriate columns.

I have searched through online templates and cannot find one which provides this functionality. Does anyone know where I could find such a template, or what formula I could enter in the chart area to give the result I am looking for?

Thanks in advance, Elliot.