How to use EXCEL Gantt chart to make a work plan

1. The user directly opens the prepared schedule. List the items related to the plan, start and end times, and the number of days each item will take. Select the data in the task name and start time column areas, and click to insert charts and bar charts.

2. Method/step Create a new EXCEL document, enter the file name, and my Gantt chart plan. Open My Gantt Chart Plan, enter the title My Gantt Chart Plan - Take Campus Recruitment Plan as an example, and then enter the time, tasks, and goal items.

3. Open excel and prepare the data to be sorted. Adjust the excel format. Generally, the excel format is time format and needs to be adjusted to normal. Select the data, click the 'Insert' menu, find the bar chart---two-dimensional bar chart---stacked bar chart, and click to select.

4. First organize your data into the following table format. In addition to the project phase name, it must include the start time and required time. Select the project phase name and start date and insert a "Stacked Bar Chart", which will generate a chart as shown in the figure. Right-click on the chart and click "Select Data".

5. The method of using excel to make a Gantt chart schedule plan is as follows: Tool: HP War 6Windows1excel2019. First select column B, press Ctrl 1 to open the Format Cells dialog box, change the format to General, and click OK.