Author: Chris Mauck

Chris Mauck, PMP, MCITP, is the lead of the PMO with Jacobs Advanced Systems Group, a subsidiary of Jacobs Engineering, in Dumfries, VA, which provides advanced technical services to the government. Contact Chris at christopher.mauck@jacobs.com.

Creating Milestone Reports in Microsoft Project

If you’re managing complex programs or large projects, a summary milestone report may be the best way to share information that shows the status of key deliverables. Yet, out of the box Microsoft Project views are limiting and don’t provide the visual summary level views that give an executive the quick overview of project or program health he or she needs for making quick and accurate business decisions. In this article I explain how to configure a view within Project that provides an executive rollup of a program showing the projects in the program with milestone status. Figure 1 shows the view that will be created through these configurations. Figure 1. The summary views we’ll create in this step-by-step guide. To display the status of each milestone graphically, milestone bar styles need to be configured for each unique status. The following logic was applied to distinguish milestones that haven’t been baselined, milestones that are on track, milestones that are delayed, and baselined milestones for those milestones that are delayed. I’ve selected the following shape types and colors to designate the status of the milestone being shown: Shape Types: Solid diamond: Completed milestone Framed diamond: Incomplete milestone Dashed framed diamond: Baseline of milestone Circle around diamond: Attention Required – Delayed incomplete milestone Color coding: Black: Not baselined Green: On or ahead of schedule Red: Delayed To create a view with these bar styles, open up the Gantt Chart View from Project or copy the default Gantt Chart View to a new view name of your choice and open up that view. To get milestones to display on a summary level bar, open up the Layout dialog by selecting Format | Layout from the Menu bar. From the Layout dialog, check the box next to “Always roll up Gantt bars” and click OK. Figure 2. Initial steps. Next open up the Bar Styles dialog by selecting Format | Bar Styles from the Menu bar. Figure 3. Laying out the specifications for illustrating milestone status. Note that the order in which you create the bar styles determines the order of how bar styles overlay on top of each other. The order in which they’re shown in the Bar Style dialog from top to bottom determines priority of sequencing or ordering of how they’re drawn on the Gantt chart view. Hence, as you’re creating bar styles, pay attention that you don’t hide something behind another bar style that you want to display. Starting at the current bar style named Milestone, rename Milestone to Milestone Complete (No Baseline) and modify the bar properties as shown in the chart below. Insert the remaining bar style names and properties after the bar style you’ve just modified. The logic of the order of these milestones creates a solid black milestone for all finished milestones and then overwrites the black milestone with a solid green milestone for those that are baselined and on time and a solid red milestone for those that are baselined and late. The same logic follows for the incomplete milestones. Table 1. How we’re ordering the milestones for this report. To add the names and dates of the milestones to the graphical display on the Gantt chart view, click on the Text tab from the Bar Style dialog and select the field to display as shown in Figure 4. Figure 4. Specifying what shows up on the graphical display. Note that if you do this for the Milestone Complete (No Baseline) and Milestone Forecast (No Baseline), the names and dates will show up for all the task level milestones, since the green and red milestones are just writing over current black milestones. Next, create bar styles for rolled up milestones. From the Bar Style menu scroll down the list of bar styles to the current *Rolled Up Milestone bar style. Change this bar style to *Rolled Up Milestone Complete (No Baseline) with the properties shown in the table below and then insert the remaining bar styles listed. Table 2. Details for bar styles to show summarized milestones. Tip: Using * in the name excludes this item from the legend when printing the Gantt chart view. To change the color of the various workstreams or project summary bars, if displaying a program level view, select the individual task row. From the Menu bar select Format | Bar to open the Bar dialog. From the Bar Shape tab, change the color under Middle, and click OK. Repeat with a different color for each workstream or project summary. Figure 5. How to specify project summary bars. Finally, to print a view for distribution, from the Menu bar select File | Print Preview. Click on the Page Setup button to open up the Page Setup dialog and customize the header and footer with a logo and custom text. Note that the legend at the bottom of the printout shows bar styles that have been designated for display. Related Content Webinars (watch for free now!): Reporting Your Way! Articles: How Many Colors Are Too Many in Your Charts?  

Webinar: Executive Level Reporting in Microsoft Project – Customizing the Gantt Chart View to Create an Executive Milestone Report – Part 2

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Strategic Category of the Talent Triangle. Part II Using Graphical Indicators and Gantt Chart Views to Create Executive Level Reporting in Microsoft Project This session is a follow up to our July WebNLearn: “Using Graphical Indicators and Gantt Chart Views to Create Executive Level Reporting in Microsoft Project” and will focus on customizing the Gantt chart view to create a rolled up milestone report. Attendees will learn how to create an Executive Level Project Milestone view in Microsoft Project through the use of filters, customization and layering of bar styles, color coding milestones and rolling milestones up to a summary level. Please click below to register and to learn more.   Presenter Bio: Chris Mauck, PMP, MCITS a Senior Program Analyst for Jacobs Technology, Mr. Mauck provides project/program management best practice guidance to the USMC’s for the Program Manager Marine Corps Network and Infrastructure Services.  Along with developing standard project management processes, Mr. Mauck has lead the deployment of the MS Project Server 2007 solution to provide visibility and standard reporting across the program.Prior to joining Jacobs, Mr. Mauck worked as a Senior Consultant for Pcubed, providing project/program management consulting services to Fortune 100 companies and major government agencies.  His experience includes implementing initiatives around strategic business process analysis, development of project management process management, rollout of enterprise project management tools, and facilitating project management process and tool training.  Focusing on people, process and tools, he assists organizations at becoming more efficient at project and program management. Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]

Webinar: Using Graphical Indicators and Gantt Chart Views to Create Executive Level Reporting in Microsoft Project

  Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is not in the PMI® system. However, it is eligible for self-directed learning PMI® PDU credit. Using Graphical Indicators and Gantt Chart Views to Create Executive Level Reporting in Microsoft Project Executives require intuitive project dash board views that provide data related to project status and support the timely decisions required to implement corrective strategies when required.  This session focuses on the development of dash board views using graphical indicators and customizing Gantt Chart views in Microsoft Project.  Through this session you will learn how to: Gather requirements to meet executive level reporting needs Apply logic to create formulas to support requirements for schedule and cost management. Creating stop light indicators. Customizing Gantt Chart Views with Indicators, Filters/Groupings and Bar Styles. Bio: Chris Mauck, PMP, MCITS Senior Program Analyst Jacobs Technology As a Senior Program Analyst for Jacobs Technology, Mr. Mauck provides project/program management best practice guidance to the USMC’s for the Program Manager Marine Corps Network and Infrastructure Services.  Along with developing standard project management processes, Mr. Mauck has lead the deployment of the MS Project Server 2007 solution to provide visibility and standard reporting across the program. Prior to joining Jacobs, Mr. Mauck worked as a Senior Consultant for Pcubed, providing project/program management consulting services to Fortune 100 companies and major government agencies.  His experience includes implementing initiatives around strategic business process analysis, development of project management process management, rollout of enterprise project management tools, and facilitating project management process and tool training.  Focusing on people, process and tools, he assists organizations at becoming more efficient at project and program management. Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]