Creating a Multi-Project Timeline using OnePager Live Web App

How to merge multiple Microsoft Project plans into a single timeline

Many project managers track individual project plans in separate Microsoft Project files. But how do you create a summary-level timeline of multiple projects, so you can see the schedule for the entire program?

This article describes how to use the OnePager Live web app to create a multi-project summary timeline, using the Microsoft Project data you already have.

  1. Start by making sure each of your Microsoft Project files has a Flag field, indicating for each task whether you want to import that task into your multi-project timeline. In the example below, we’ve inserted the Flag20 column, marking those tasks we want to appear in our timeline with Yes.
  2. Microsoft Project file with a Flag field displaying.
  3. Then login to OnePager Live. Don’t have OnePager Live yet? Sign up for free to learn more.
  4. After logging in, from the Start screen, choose New.
  5. OnePager Live Start screen.
  6. You'll want to name your Project View (OnePager document). In this example, we'll call it "Project Portfolio - Tasks by Project".
  7. Select the Microsoft Project files you want to use to build your multi-project timeline. You can either pull these files from your local computer by clicking Import File(s) and then Choose Files, or from Microsoft Project Server by clicking Microsoft Project Server Plan(s) and selecting the desired Project Server files from the dropdown menu.
  8. Choose which Microsoft Project plans to import.
  9. From the Template dropdown list, choose the preloaded template called Multi-Project Gantt Chart - Detailed. This template contains a set of pre-configured settings that make it easy for you to build multi-project presentations. You can always change these settings later.
  10. Specify the Flag field you will be using to indicate which tasks you want to pull in to your OnePager document. In this example, we’ll use Flag20.
  11. Select your OnePager Live template and Flag field.
  12. Specify a Snapshot date for your portfolio schedule to represent the point in time the OnePager document they are looking at will be accurate to.
  13. Click Create new project view. OnePager will import your selected tasks and milestones and create a high-level portfolio view that shows the schedule for each individual project plan. Your OnePager result will be driven by your template that was selected earlier and may look like this:
  14. Easy multi-project timeline created using the OnePager Live web app.

It's that easy!

How much time and frustration could OnePager Live save you? Sign up for free today to learn more.

Sign Up for Free