Reporting tools like OnePager Pro for Microsoft Project allow you to import information about multiple projects in a portfolio, apply color-coding, and quickly create a portfolio-level status report based on your data. Don't have OnePager Pro yet? You can download a free trial and try it out today.
OnePager Pro can create a portfolio stoplight chart like this in minutes:
Here's how to get started:
- Begin with your portfolio of projects. They can either be consolidated into a single Microsoft Project plan, as shown below, or can be tracked in separate Microsoft Project files. The end result is the same.
- Select the key milestones for each project by placing a "Yes" into a flag column. In this case, we'll use "Flag 20" to choose which key milestones will be included in the portfolio stoplight chart.
- Now double-click the OnePager Pro icon on your desktop to start building your portfolio stoplight chart. From the Start screen that pops up, choose New.
- Choose your Microsoft Project plan as the source file for your OnePager Gantt chart.
- When the import wizard then appears, go to the Starting Template section, click Change..., then BROWSE..., and then select the "Status (RAG) View" template that comes with the software. This template will automatically color-code tasks and milestones based on their status. You can always re-configure your report later, but this will be a good starting point:
- Type in a name for your portfolio report, and pick today’s date as your snapshot date, as shown below:
- Click the Create New Project View button, and OnePager Pro automatically creates a portfolio stoplight chart for the selected milestones in each project:
- For a tighter view, go to Home > Project-View Properties > Rows/Swimlanes, and tell OnePager Pro to put all milestones for a given project in a single row:
- Click OK, and OnePager Pro will rebuild your portfolio stoplight chart with each project's milestones lined up left-to-right, and color-coded in red, yellow, and green:
Want to know how these colors and shapes were automatically assigned? One of OnePager Pro's key capabilities is that it adds conditional formatting to Microsoft Project. This means that OnePager Pro looks at your Microsoft Project plan and assigns colors, shapes, and fonts automatically based on your data. You don't have to spend time building reports by hand in PowerPoint.
You can see how OnePager Pro's conditional formatting for Microsoft Project works by going to Home > Project View Properties > Milestones and then clicking on the Manage Rules button. This particular example is simple; it assigns a different color and shape for each value in the Microsoft Project "Status" column, which is automatically populated for you.
OnePager Pro's conditional formatting feature is very flexible; if you need something more complex than the simple example shown here, OnePager Pro can handle it for you.
OnePager is the most professional way to create a portfolio stoplight chart, and is used worldwide by industry-leading PMOs for this very reason. If you are using Microsoft Project to track your portfolio, you already have all everything you need. Just import your portfolio from Microsoft Project into OnePager Pro, and you will get a portfolio stoplight chart in a matter of minutes.15-Day