Hi,
I can see on the forums that lot of MS PROJECT 2016 user have problem with graphical indicators. For example, they want to see Actual Work compared with base lined work, and see the status. OK, that is not so complicated. Let’s say that you want to compare Actual work with Baseline work in a way that:
If Actual work is equal or lower than Baseline work – you want a Green indicator
If Actual work is up to 20% higher than Baseline work – you want a Yellow indicator
If Actual work is more than 20% higher than Baseline work – you want a Red indicator
Firs of all I am going to create Simple Project with three Tasks and three Resources:
and:
Finally I’m going to assign them to Tasks:
Now I’m going to create one Custom field – Number:
and then:
and then:
Now I’m going to save the Baseline:
and, finally I am going to include all relevant fields in Gantt Chart:
Now I’m going to put some Actual work:
As you can see, I’ve got what I want. Notice this little tip. If you put checkmark here:
and you hoover your mouse on the Graphic Indicator, you will se Value:
With this you can see actual value of this custom field, and you can check if your formula works properly!
Regards!
Like this:
Like Loading...
Related
About Nenad Trajkovski
Location: Zagreb, Croatia
Occupation: Project Manager
Interests: Project Management and MS PROJECT
He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
Nenad Trajkovski 
marvelous