Excel is the most widely used tool for dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. In Excel, you can plan and set a timeline for your project by creating a Gantt Chart. Moreover, you can also show dependencies in the chart. In this article, I will show you how to show dependencies in Excel Gantt chart.
Download Practice Workbook
Download this workbook and practice while going through this article.
Introduction to Gantt Chart and Dependency
A Gantt chart is a graphical representation of the schedule of a project. All the tasks associated with the project are put on a timeline to get an overall idea of the project. An individual bar represents the duration of a task.
Dependency is the logical relationship between these tasks. For example, sometimes the initiation of a task depends on the completion of another task. In that case, we can say that the former task is dependent on the latter one.
2 Quick Methods to Show Dependencies in Excel Gantt Chart
This is the dataset for today’s article. We have some tasks along with their Proposed Start Date and End Date. Due to the dependencies, the proposed start dates are different from the actual start dates.
This is a simple Gantt Chart for this project based on the Proposed Start and End Date.
I will explain how to show dependencies in Excel Gantt Chart with 2 different cases now.
Method 1: Show Dependencies When Equipment Is Not Ready
The start of a task may delay for various reasons. These may include a shortage of raw materials, malfunctioning machines, etc. In our dataset, even if Task B is complete on the 24th of April, we will have to wait to initiate Task C. The delay is 2 days.
Let’s show it on the Gantt Chart.
- Go to the Insert tab >> Illustration >> Shape >> Select Line.
- Then draw two tangents that will represent the delay in start.
Read More: How to Add Milestones to Gantt Chart in Excel (with Quick Steps)
Method 2: Show Dependencies When Predecessor Is Not Complete
Now, I will discuss another case. You will see that the proposed date to start Task D is the 6th of May. However, Task C will finish on the 10th of May. As Task D will initiate only after the completion of Task C, we cannot start Task D on the 6th of May. We have to delay. Because the predecessor of Task D is Task C which will complete on the 10th of May.
Let’s show this dependency on the Gantt Chart.
- Go to the Insert tab >> Illustration >> Shape >> Select Line.
- Then show the interdependencies by drawing the lines.
Things to Remember
- You can format the shapes from the Shape Format
Conclusion
In this article, I have explained how to show dependencies in Excel Gantt Chart with 2 simple cases. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.