Gantt chart-Excel, Gantt Chart excel

Gantt chart-Excel, Gantt Chart excel
1. Gantt Chart

Concept

A Gantt chart is a type of bar chart. Gantt chart is one of the earliest attempts to associate activities with time based on the purpose of sorting jobs. What does this mean? That is to say, Gantt chart is used to indicate the time at which to do things. It is equivalent to a plan arrangement, and can well represent the execution sequence of things and the progress of work.

Benefits

1. intuitive and clear (graphical overview)
2. Easy to understand (easy to understand)
3. Wide application (General Technology)

Defects

1. Gantt Chart actually only partially reflects the three constraints (time, cost, and scope) of project management, because it mainly focuses on process management (time );
2. Software deficiency. Although project management software can be used to depict the internal relationship of project activities, if there are too many relationships, the complicated line chart will certainly increase the reading difficulty of Gantt charts;

In addition, the personal Gantt chart and the schedule we use are two different task expressions. The personal Gantt Chart allows you to intuitively know which tasks are to be performed in what time period, while the timetable provides more accurate time period data. In addition, you can directly update the task process in the schedule.

2. Make Excel2010

Open excel2010 and prepare the data to be sorted.

Adjust the excel format. Generally, the excel format is in the time format and needs to be adjusted to the regular format.

Select data, click the 'insert' menu, find the bar chart-two-dimensional bar chart-stacked bar chart, and click Select.

Display the time bar above to facilitate viewing. Right-click the Y axis of the generated graph, set the axis format, and select the Reverse type.

Set the x-axis attribute to display the start position at the origin and adjust the spacing as appropriate.

Select the image in the list, right-click the blue part, and set the data series format to "unfilled.

Restore the cell format of the previously set date. You can complete the Gantt chart effect, drag and adjust it as needed.

3. Conclusion

According to the introduction in this article, Gantt chart is essential as part of project management. It not only reflects the task division of the entire stage, but also reflects the current progress. At the same time, we also introduced how to draw Gantt charts through Excel, and hope we can use them flexibly in future work to help us better manage our projects.