How to use Excel to draw a Gantt chart

Gantt Chart Small partners are very familiar with the first small part of the simple to the small partners to introduce the above is a Gantt chart, the internal idea of the Gantt Chart is simple, that is, graphically through the activity list and the timescale to represent the activity of any particular project sequence and duration. It is basically a line chart, the horizontal axis represents the time, the vertical axes represent the activity (the project), and the line represents the completion of the planned and actual activities throughout the period. It visually shows when a task is planned, and how the actual progress is compared to the plan requirements. This makes it easy for managers to figure out what remains to be done in a task (project) and to assess the progress of the work.

Still remember in the soft exam, Gantt chart often and pert diagram put together, examine us, since the mention of PERT, small part also simple introduction of what is Pert,pert also called "Planning Review Technology", it uses network diagram to describe a project's task network. Not only can you express the scheduling of subtasks, you can also estimate the completion of tasks during task scheduling, analyze the global impact of some subtask completion, and identify the regional and key subtasks that affect the overall situation. In order to take timely measures to ensure the completion of the entire project. Small series internship back, and then, received a project, and glorious appointment for the group leader, small series want to say is, I have not been brought, take someone else, certainly put her little partner to the pit, but it doesn't matter, the more the better, so small series will grow more beautiful, to the present stage, as the leader, Should be the whole project cycle has a macro control, each stage should need to do something, these are very important drops, today this blog, small series on simple want to introduce you small partners, how to use Excel Gantt Chart, also please small partners to advise.

The first step is to open Excel on your partner's computer, prepare the data already in OneNote, and take the example of the municipal organization department review Project, which is now taking over, as shown in:

In the second step, select the sign in and out of all icons, and select all the bars in the chart as shown in:

The third step: the resulting icons are as follows:

Fourth step: Select the chart, select all data into the data area, including the task, start time, duration, finish time, delete the completion time series, and ensure that the starting time is above the duration, as shown in:

Fifth step: The diagram formed by the wizard has been completed, then proceed to the next step, reverse the y-axis, double-click the y-axis coordinates in the graph, in the pop-up dialog tick column, tick the category order reversal option, as shown in:

Sixth step: Hide the Start time series, double-click the starting time of the bar area, in the popup dialog box, make the settings as shown:

Seventh step: Double-click the x-axis, the specific operation as shown, warm reminder, the minimum value entered here in fact, the earliest date of November 30, 2015, Excel will convert itself to a number, the maximum value and so on.

Eighth step: Let's take a look at what our Gantt chart looks like, as shown in:

At this point, how to use Excel to draw a Gantt chart of the small series has been introduced.

Small Series of words: This blog, small series of the main simple introduction of how to use Excel Gantt Chart, in fact, there are many software in the actual application can help us to achieve similar functions, but the comparison pit is, downloaded a software, in the installation of the time, To small series of computers on the computer inexplicably installed a variety of software, resolute Uninstall, or Excel use ' (*∩_∩*), municipal Committee of the Department of assessment projects, wonderful not to be continued ~ ~ ~ ~

How to use Excel to draw a Gantt chart