In Microsoft Project you can display different project information next to the task bars in a Gantt Chart. This ensures that you can see the information you need to see about a task without having to keep looking over to the table.
You can display the information in different positions in relation to the bars such as to the left, right, above, below or in the middle. However, Project only allows one piece of information per position.
This can limit the feature somewhat so we will look at how to add multiple fields next to the task bars in a Gantt Chart.
I am often asked in Microsoft Project courses how to automatically change the colour of the task bars in a Gantt Chart dependent upon the tasks resource, or location.
The truth is that this can be a complicated process, but once it is set up it is good to go. Save your view and you will never have to worry about it again.
In this example I plan to format the colour of the task bars by the resource group. I want the colour of the bars to indicate the team that are working on that task. When someone assigns a resource to a task, Project will automatically format the task bar colour in the Gantt Chart.
A Gantt chart is used to plan and track the progress of a project. Although Excel does not contain a Gantt chart feature (maybe one day), its tabular structure and wealth of tools provide us with the means of creating one.
A Gantt chart can be created in many ways to match your requirements.
Using the Excel Gantt Chart Template
This Excel Gantt chart template uses fixed scheduling on its tasks and provides a timescale of 1 full year from the project start date. To use the template;
- Enter the project start date in cell E1.
- Enter the ID and name for the tasks of your project.
- Enter the task’s estimate start dates and durations.
- Enter the % completion to update the chart with the progress of the project.