September 21
How to Create Multi Color Summary Bar Based Upon Phase
The following steps will show you how to create this:
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:
- Select the Milestones, right click and click on Task Information.
- Place a check in “Roll up to Gantt bar to Summary”
- Click on OK. Rolled up Milestones will now appear on Summary Bars
- Right click on the Gantt Chart and click on Bar Styles
- Click on *Rolled Up Milestone, then click on the Text tab. For Bottom, select Name.
- Click on OK. Milestone Names will now appear below the Rolled up Milestones on the Summary Bars
- Insert Flag 1, Flag 2, and Flag 3 columns
- Right click on Flag 1 and click on Customize Fields
- Click on Rename and input “Planning Flag”
- Click on OK
- Click on Formula
- Input the following formula: [Name]=“Planning”
- Click on OK
- For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.
- Click on OK
- “Yes” should now automatically appear under the Planning Flag for the Planning Summary Task:
- Right click on Flag 2 and click on Customize Fields
- Click on Rename and input “Execution Flag”
- Click on OK.
- Click on Formula
- Input the following formula: [Name]=“Execution”
- Click on OK
- For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.
- Click on OK
- Right click on Flag 3 and click on Customize Fields
- Click on Rename and input “Closure Flag”
- Click on OK.
- Click on Formula
- Input the following formula: [Name]=“Closure”
- Click on OK
- For “Calculation for task and group summary rows”, ensure “Use Formula” is enabled.
- Click on OK
- You may now hide the three flag fields
- Click on Show Outline Level 1
- Right click on the Gantt chart area and click on Bar Styles
- Under Name, click on Summary
- Click on Cut Row
- Click on Paste Row four times
- Move to the second Summary under Name and input “Rolled Up Summary Planning”
- 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
- 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.
- Complete steps 43 through 45 for the 3rd and 4th Rolled Up Summary
- Click on OK. Colors will now appear on Summary row
- To add the Phase Names below each phase, right click on the Gantt Chart and click on Bar Styles
- Click on Rolled Up Summary Planning under Name
- Click on the Text Tab
- For Bottom, Select Name
- Click on OK
- Complete steps 49 through 52 for Rolled Up Summary Execution and Rolled Up Summary Closure
- Click on OK
