1. Open the EXCEL table, select cell D 1, and enter the project plan start time.
2. Select Edit-Fill-Sequence.
3. Fill in the planned end time in the end value, and click OK to generate the date series horizontally.
4. Select the cells that will generate the Gantt chart.
5. Select the conditional format and create a new rule.
6. In the new format rule, select Use Formula to determine the cells to be formatted.
7. Enter a formula in the formula box, which means: "Is the date corresponding to each cell in the selected area within the range of plan start and plan end?" Select a format.
8. Select the border again, leaving only the top and bottom borders.
9. In terms of color, choose to fill with white to avoid overlapping Gantt chart color blocks of each task.
10. Select a fill and click any color.
1 1, and click OK.
12, you can generate a Gantt chart.
That's all about how excel can quickly make Gantt charts.