How to Create Gantt Chart Template Using MS Excel or MS Word
Sponsored Links
A Gantt chart, the name of the American Mechanical Engineer, Henry Laurence Gantt, who became popular around these letters 1911-1916, is a graph that shows graphically how your proposed work is progressing with time.
Creating a Gantt chart template in Excel or Word is easy and while doing so you also learn how Excel or Word handles dates and other interesting features.
As all the projects can be divided into many tasks. Each task has a start date, the time required to complete the task and therefore an end date. Entering this data into separate columns with the headings: tasks, Star Date and Time Required (days), date of completion. Now select your data including the headers, click in the wizard graph, bar graph and the sub-table named ‘cell bars. ” Once you click “OK” is the bar graph.
Now you need to format the chart appropriately. The bar graph is displayed with the work of up and down. You can reverse this so that the 1 appears in the first place. Double click on the category axis’, select Scale, and then select the categories in reverse order. “Now you can find the numbers that correspond to the dates by clicking on the cell the date of the first task, select ‘Format cells … “and the number in the window that appears. Write the numerical value on the date. Do the same with the end of the last task. Next double-click the value axis that has the above dates. In the minimum and maximum value of text boxes in the “Format Axis” window under the scale, the input values. Then select the blue bars represent the start dates of each task, click the button “select format data series” and the pop-up window under the guidelines select ‘none’ on the border and “in any area.” Gannt Your table is ready. If you like what you can modify by changing the size of the tasks and dates.
Although a simple Gantt chart, but it serves the purpose of understanding what are Gantt charts and how they help us in monitoring our projects. And you used your Excel without further investment.