How to setup complex Graphical Indicators with MS PROJECT 2016

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:

    image

    and:

    image

    Finally I’m going to assign them to Tasks:

    image

    Now I’m going to create one Custom field – Number:

    image

    and then:

    image

    and then:

    image

    Now I’m going to save the Baseline:

    image

    and, finally I am going to include all relevant fields in Gantt Chart:

    image

  • Now I’m going to put some Actual work:

    image

    As you can see, I’ve got what I want. Notice this little tip. If you put checkmark here:

    image

    and you hoover your mouse on the Graphic Indicator, you will se Value:

    image

    With this you can see actual value of this custom field, and you can check if your formula works properly!

    Regards!

    Advertisements

    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)!
    This entry was posted in MICROSOFT PROJECT, Microsoft Project 2013, MS PROJECT 2016, PMI, PRoject Management and tagged , . Bookmark the permalink.

    One Response to How to setup complex Graphical Indicators with MS PROJECT 2016

    1. Andrew says:

      marvelous

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s