Best Microsoft Excel Bloggers

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:



2 comments:

  1. Thanks for this knowledge sharing. It encourage me to learn more about excel

    ReplyDelete
  2. good Excel trick! thank you for sharing it

    ReplyDelete


Ms. Excel- Resident Excel Geek