This is a example spreadsheet that shows how you can create your own gantt charts easily. All you have to do is check the task and then click the chart given it will show you the formula in the formular bar. You can try this relationship in creating gantt chart for different type of data.
