Graphical Indicators

Resolved · Urgent Priority · Version 2010

Wed 18 Jan 2012, 15:55 Edited on Fri 20 Jan 2012, 10:04 Delegate Ajibola said...

Ajibola has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Excel Dashboards for Business Intelligence course

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.

Thu 26 Jan 2012, 14:27 Edited on Thu 26 Jan 2012, 14:28 Trainer Rodney said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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