advanced ms project

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Graphical Indicators

Graphical Indicators

resolvedResolved · Urgent Priority · Version 2010

Edited on Fri 20 Jan 2012, 10:04

Graphical Indicators

How do I use graphical indicators to show 100% completed tasks show blue flags:

Tasks late for more than 2 days show red flags;

and tasks on schedule show green flag.

Edited on Thu 26 Jan 2012, 14:28

RE: Graphical Indicators

Hello Ajibola,

I have provided a file for you which contains a RAG Status column in the Tracking Gantt view using the Variance table. The baseline must be set before the project begins!

The formula is as follows:

IIf([Status]=0,1,IIf([Status]=1,3,IIf([Finish Variance]>2,2)))

0 status = Complete
1 status = On schedule

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

Project with Status.zip


 

MS Project tip:

Create own ribbon tab - Project 2010

a. In Project click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all MS Project hints and tips


Server loaded in 0.08 secs.