Tuesday, September 22, 2015

Creating a Gantt Chart in Excel

Cam't afford fancy software for project scheduling? Try using Excel.

The image below is the end result we will achieve.




In this example, we took each activity and provided a sideways bar to visually show when that activity occurred within the total project. 

To accomplish this we will be using some logic functions as well as conditional formatting.
The project example we are going to use is below: