OnePager's patented conditional formatting tool works directly with Microsoft Project to create beautiful timelines like these. Sign up for a free trial and try it out today.
Here is how to build a project timeline with conditional formatting:
Let's start with a Microsoft Project plan. If your Microsoft Project plan has lots of tasks, it's a good idea to use a flag field like Flag20 to select the items that you want to include in your project timeline:
Launch OnePager Pro. You can either do this from your desktop, or from inside Microsoft Project on the Add-Ins tab:
Click NEW to start building your project timeline:
On the next screen, we'll pick a template that is specifically set up to create a project timeline. In the Starting Template section, click Change > BROWSE FILES to browse the available OnePager templates:
Here, we'll select the Single Project Timeline template:
Give your chart a name, and then click the Create New Chart button. OnePager will import your tasks from Microsoft Project and create an initial timeline that you can customize:
The initial timeline that OnePager creates has a swimlane for each phase of the project, and within each phase, all tasks are lined up left-to-right in a timeline layout.
This first timeline is assigning color by phase, where each phase of the project gets its own color. This is a good start, but if you want to assign colors some other way, this is where OnePager's patented conditional formatting can really be useful. To turn off the default color-coding, go to Home > Chart Properties > Task Bars, and set the chart to only Use one color:
When you click OK, the initial phase-driven color will be removed from the project timeline:
The initial timeline that OnePager creates has a swimlane for each phase of the project, and within each phase, all tasks are lined up left-to-right in a timeline layout.
With the phase-driven colors gone, we can click on Manage Rules to launch a separate window for Conditional Formatting. Here, we've written a few example rules that assign colors based on the status of each task. For example, completed tasks are green and late tasks are red:
The use of the Status field is only an example. Any field from Microsoft Project or Project Online can be used to drive conditional formatting in OnePager. Furthermore, conditional formatting isn't limited to just color. You can use it to assign different milestone shapes, colors, borders, and more.
Click OK two final times, and you'll see OnePager re-color your project timeline based on the status information from Microsoft Project:
OnePager not only creates timelines from Microsoft Project, but enables you to apply conditional formatting that makes it easy to see status, resource assignment, or any other aspect of your project that requires visibility.
Create your own project timelines with conditional formatting today by downloading a free trial of OnePager Pro.
15-DayFree Trial