Well designed gantt chart with different sheets, you have to input the data in one of the sheet which will result into the display of the gantt chart in the second spreadsheet. There is also an tutorial on how to create an gantt chart by yourself. You can enter the start up date and the date of completion of the work.

image