In this tutorial I will explain on how to create the “Graphical Indicators” which can be used to represent status of the project activities visually. Tutorial specificaly details on how to create graphical status indicators in Gantt Chart Microsoft Project. Graphical indicators are visual representation of the status of the tasks based on the percentage completion. Visual representation gives a quick overview of all tasks status. This is a quick and easy way to read through your project gantt chart to identify or segregate tasks that are completed or running late.
Scenario 01: Assign Green indicator for project activities that are 100% complete.
Scenario 02: Assign Red indicator for project activities which passed the Finish date and are not 100% complete.
Scenario 03: Assign Red Flags for activities that are 0% complete and has passed the planned start date.
Scenario 04: Assign Yellow indicator for activities that are upcoming in 2 weeks. ( you can alter this to 1 week or 2 days etc based on your requirement)
Scenario 05: Assign White indicator for project activities that are yet to start.
Scenario 06: Assign Dark Green indicators for all other project activities which doesn’t fall in to any of the above scenarios.
Now lets see the formula to see how we can achieve the above scenarios using IF expression in MS Project.
IIf([% Complete]=100,4,(IIf([Current Date]>=[Finish],3,(IIf([Current Date]>[Start] And [% Complete]=0,5,(IIf([Current Date]>[Finish]-14 And [% Complete]<80,2,(IIf([Current Date]<[Start],6,1)))))))))
As you know the MS Project can return numerics for the true & false part of the expression. So the numbers used in the above formulas showed be now mapped to respective colors in the graphical indicator button in the formula window.
Checkout my Youtube channel to see the video tutorial. Please like the video and subscribe for more content.