Rich's profilePMConnection ArticlesBlogLists Tools Help

Blog


    September 21

    Dynamic Color Coded Phases

    How to Create Multi Color Summary Bar Based Upon Phase

    The following steps will show you how to create this:

    clip_image002

    Note that color formatting is dynamic and will adjust as Duration of the phase increases or decreases.

    1.  Must establish consistent Phase names. Example:

    - Planning
    - Execution
    - Closure

    2.  Must establish consistent Milestone names. Also useful to have Acronym for milestone names. Example:

    Milestone - Acronym
    - Planning Complete – PC
    - Execution Complete – EC
    - Closure Project - CP

    3.  Open MS Project

    4.  Establish Phase Names and Milestone Names:

    clip_image004

     

    1. Select the Milestones, right click and click on Task Information.

    clip_image006

     

    1. Place a check in “Roll up to Gantt bar to Summary”

    clip_image008

     

    1. Click on OK. Rolled up Milestones will now appear on Summary Bars

    clip_image010

     

    1. Right click on the Gantt Chart and click on Bar Styles

    clip_image012

     

    1. Click on *Rolled Up Milestone, then click on the Text tab. For Bottom, select Name.

    clip_image014

     

    1. Click on OK. Milestone Names will now appear below the Rolled up Milestones on the Summary Bars

    clip_image016

     

    1. Insert Flag 1, Flag 2, and Flag 3 columns

    clip_image018

     

    1. Right click on Flag 1 and click on Customize Fields
    2. Click on Rename and input “Planning Flag”

    clip_image020

     

    1. Click on OK
    2. Click on Formula
    3. Input the following formula: [Name]=“Planning”

    clip_image022

     

    1. Click on OK
    2. For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.

    clip_image024

     

    1. Click on OK
    2. “Yes” should now automatically appear under the Planning Flag for the Planning Summary Task:

    clip_image026

     

    1. Right click on Flag 2 and click on Customize Fields
    2. Click on Rename and input “Execution Flag”
    3. Click on OK.
    4. Click on Formula
    5. Input the following formula: [Name]=“Execution”
    6. Click on OK
    7. For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.
    8. Click on OK
    9. Right click on Flag 3 and click on Customize Fields
    10. Click on Rename and input “Closure Flag”
    11. Click on OK.
    12. Click on Formula
    13. Input the following formula: [Name]=“Closure”
    14. Click on OK
    15. For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.
    16. Click on OK

    clip_image028

     

    1. You may now hide the three flag fields
    2. Click on Show Outline Level 1

    clip_image030

     

    1. Right click on the Gantt chart area and click on Bar Styles
    2. Under Name, click on Summary
    3. Click on Cut Row
    4. Click on Paste Row four times

    clip_image032

     

    1. Move to the second Summary under Name and input “Rolled Up Summary Planning”

    clip_image034

     

    1. Move to the Show For column, input a coma after Summary, click on the dropdown, select Rolled up. Input a coma after Rolled up, click on the dropdown and select Flag 1. Then click on Rolled up Summary Planning

    clip_image036

     

    1. On the Bars tab for Start, Middle and End, click on the dropdown and select the color you would like to appear for the Planning Phase.

    clip_image038

     

    1. Complete steps 43 through 45 for the 3rd and 4th Rolled Up Summary

    clip_image040

     

    1. Click on OK. Colors will now appear on Summary row

    clip_image042

     

    1. To add the Phase Names below each phase, right click on the Gantt Chart and click on Bar Styles
    2. Click on Rolled Up Summary Planning under Name
    3. Click on the Text Tab
    4. For Bottom, Select Name

    clip_image044

     

    1. Click on OK
    2. Complete steps 49 through 52 for Rolled Up Summary Execution and Rolled Up Summary Closure
    3. Click on OK

    clip_image045