Excel2103 Making Gantt Chart

2. Then, click the icon wizard button to enter the dialog box, as shown:

Excel2103 Making Gantt Chart

3. Select "Stacked Bar Chart" in "Bar Chart", and the next step appears as shown in the figure.

Excel2103 Making Gantt Chart

4. Select all data in the data area (including four columns of task, start time, duration and completion time), and delete the series of "completion time" to ensure that the "start time" is above the "duration", as shown in the figure below:

Excel2103 Making Gantt Chart

5. Click Finish, and the chart is as follows:

Excel2103 Making Gantt Chart

6. The chart formed by the wizard program has been completed. Next, proceed to the next step: reverse the Y axis: double-click the Y axis coordinate in the chart, and check the "reverse the sorting order" option in the scale bar of the pop-up dialog box, as shown in the following figure:

Excel2103 Making Gantt Chart

7. After inversion, as shown in the figure:

Excel2103 Making Gantt Chart

8. Hide "Start Time" series: double-click the "Start Time" column area and set it in the pop-up dialog box:

Excel2103 Making Gantt Chart

9. Double-click the X axis, and a dialog box will appear on the right side of the picture. Follow the text prompts in the picture: