OnePager Pro is presentation software for Microsoft Project that lets you automatically add and update RAG status to your project plans without spending any time drawing things by hand in PowerPoint. Don't have OnePager Pro yet? You can download a free trial and try it out today.
You can do this by following these easy steps:
- Start with a Microsoft Project plan. Notice that Project is automatically calculating a status for you:
- To build your RAG project report, double-click the OnePager Pro icon on your desktop. From the Start screen that pops up, choose New.
- In the import wizard, choose your Microsoft Project plan as the source file for project timeline. Then go to the Starting Template section, click Change..., then BROWSE..., and find the Status (RAG) View.tat template. This will build a RAG project report for you very quickly.
- Click Create new Chart. OnePager will import your Microsoft Project schedule and automatically color-code each task based on its status:
Conditional Formatting
Curious how this works? OnePager Pro adds conditional formatting to Microsoft Project, meaning you can set up special rules to look at your Microsoft Project data and assign colors, shapes, and fonts automatically.
Going to Home > Chart Properties > Task Bars and then clicking on the Manage Rules button will show you the default rules that are set up to assign different styles based on the “Status” column in Microsoft Project. OnePager Pro is flexible, so you can set up other rules to look at different Microsoft Project columns if you’d like:
OnePager Pro’s conditional formatting for Microsoft Project becomes even more powerful as your project plan changes. Let’s say that three months has gone by, and the status of your project plan has changed. You can simply refresh your existing OnePager Pro report, and have it automatically update your dates and status colors based on the revisions you have made in Project. Here’s how:
- Make the necessary changes to Microsoft Project.
- Open your original RAG status report, and go to Data > Add Snapshot. Pick a new status date for your updated report:
- OnePager will reimport the status information from Microsoft Project and will assign new RAG colors:
Notice that as the status changes in Microsoft Project, OnePager Pro automatically re-formats each task and milestone on the chart based on your conditional formatting rules. Tasks that were previously yellow are now red because their status has changed. This is the quickest and easiest way to create a project status report, because it’s 100% dynamic and data-driven.
OnePager makes it easy to represent a project’s status with compelling graphics. OnePager is available in two versions: one supporting Microsoft Project (OnePager Pro) and the other supporting project plans built in Excel (OnePager Express).
Get started today by downloading a free trial.
15-DayFree Trial