Follow these steps to make a Gantt chart in Excel from scratch. Step 1: ... You can manually enter the duration of the task or use one of these Excel formulas to fill in those cells automatically: ...