OnePager's powerful conditional formatting engine connects with Microsoft Project and Project Online to build eye-catching Gantt charts like these. Sign up for a free trial and see how it works for your projects.
Follow these steps to add conditional formatting to your Gantt chart:
Open your Microsoft Project plan. If your project is larger, you can add a filter field like Flag20 to include or exclude details from your Gantt chart:
Go to Microsoft Project's Add-Ins tab and click the OnePager Pro button:
Click NEW to begin building your Gantt Chart:
Give your Gantt chart a name, and then click the Create New Chart button:
OnePager will import your selected tasks and milestones from Microsoft Project, and will create an initial Gantt chart that you can start customizing. Initially, OnePager assigns colors based on the phases of your project:
This is a good start, but if you want to assign colors some other way, this is where OnePager's conditional formatting is really powerful. To turn off the default colors, go to Home > Chart Properties > Task Bars, and set the chart to only Use one color:
When you click OK, the Gantt chart will default to a single gray color:
The remaining yellow colors in the chart are the progress bars, which are reporting on your Percent Complete information from Microsoft Project.
Return to Home > Chart Properties > Task Bars and click on Manage Rules to launch OnePager's Conditional Formatting rules:
- Here a few example rules that assign colors based on status. When a task is late, we'll color it red, and when a task is complete, it can be green. In addition to assigning colors based on status, we can also assign different milestone shapes conditionally. Still looking at the status, we can put a checkmark for completed milestones and an "X" for late milestones:
We're using the Status field from Microsoft Project as an example. OnePager's conditional formatting will work with any other field from Microsoft Project or Project Server if you want to use something different.
Click OK, and OnePager will reformat the shapes and colors in your Gantt chart based on the status of your Microsoft Project plan:
OnePager not only creates Gantt charts from Microsoft Project and Project Online, but makes it easy for you to add conditional formatting to your Gantt charts so that you can quickly communicate status and other key project metrics.
Create your own conditionally-formatted Gantt charts today by downloading a free trial of OnePager Pro.
15-DayFree Trial