On the category axis, the “Board Meeting” takes position at the top, but in project management data, Planning Meeting is topping, I double click on the category axis, and in the Axis options, I reverse the category order. I delete the legend and make the chart a little bit wider. I select a cell within the data, Insert tab, in Bar chart drop-down, I select Stacked Bar chart. ![]() ![]() The same values are in the second worksheet. OK, let’s start creating this Gantt Chart. One important thing is: column A must not have any heading, otherwise column A and column B both will be used as the category axes. Column A contains the task name, column B contains the start date of the task, and column C contains the duration to finish the task. So Gantt chart is very important in project management. The project manager can easily identify the overlapping tasks of the Project. ![]() The horizontal axis represents the total time span of the project, each bar represents the duration of a task. In the worksheet, you see a simple Gantt Chart, created using this piece of data. But you can create an advanced level Gantt chart in Excel. By default, Excel does not support any Gantt type chart. ![]() Gantt chart is used basically in project management. A Gantt chart is a horizontal type bar chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |