sales@onepager.com +1.303.779.0344

Primavera P6 Multi-Project Gantt chart

Combine several Primavera P6 projects into a OnePager Gantt chart.

OnePager Express builds Gantt charts using multiple project schedules from Primavera P6, like this:

Gantt chart of multiple Primavera P6 projects created in OnePager.

OnePager Express uses an Excel export of multiple Primavera P6 projects to create your Gantt chart. If you don't already have OnePager, download a free trial and follow the steps below.

  1. Start in Primavera P6, where you have multiple project schedules. In this example, we will use Project A and Project B:
    Multiple projects in Primavera P6
  2. Next, export your Primavera P6 projects to Excel. To do this, navigate to File > Export and pick the Spreadsheet - (XLSX) option. Click Next.
  3. For your Export Type, choose Activities and click Next. Select both Project A and Project B for export and then hit Next once more:
    Export multiple projects from Primavera P6
  4. If you've already built an Excel export template in P6 for something else, you can use that. If you don't have an Excel template yet, you can set up a custom one for OnePager. Your Gantt chart will look best if you include these fields from P6::
    Export fields from P6 into Excel for use with OnePager.
  5. Finish the export to Excel from Primavera. Each project plan from Primavera P6 will create a separate Excel file.
  6. RECOMMENDATION: When Primavera P6 exports schedules to Excel, it creates two sets of column headers. The second row is more user-friendly. You can use either header, but we recommend removing the first row so that the user-friendly names move to the top row. Make sure to do this for BOTH Excel files:
    Delete the first row from your P6 export.
  7. Double-click the OnePager Express icon on your desktop to start building your multi-project Gantt chart:
    OnePager Express imports P6 data via Excel.
  8. On the start screen, hit NEW to create a new multi-project Gantt chart:
    Create a multi-project Gantt chart from Primavera P6
  9. On the next screen, click Select and then Browse Files to pick up your exports from Primavera P6.
    Browse to the folder that contains your P6 exports.
  10. Pick your first project schedule, then click Add/Remove to attach the rest of them. Once all of your projects are shown, click OK
    Import multiple Primavera P6 exports into OnePager.
  11. Name your Gantt chart, select one of OnePager's multi-project templates, and then click Next:
    Use a multi-project template
  12. Double-check to make sure that OnePager has chosen the correct fields from P6 to use in your Gantt chart. Make any necessary changes, and then click on Create new Project View to build the report.
    Map Primavera P6 fields into a OnePager Gantt chart.
  13. OnePager will import both of your Primavera P6 schedules and create an initial Gantt chart. We'll want to make a few customizations to get it to look the way we want.
  14. To group and sort your Gantt chart into swimlanes by project name, go to Home > Project View Properties > Rows/Swimlanes and change your swimlane settings to group by the "Project Name" field from Primavera P6:
    Group your Gantt chart into swimlanes based on Project Name from Primavera P6.
  15. This will give you a project-by-project Gantt chart, which is what we need:
    Primavera P6 Gantt chart with multiple projects.

After building your draft Gantt chart, you can fine-tune the formatting, including color, layout, time units, and a lot more. You can even insert additional project schedules from Primavera P6 if you need to expand your Gantt chart to include more projects than you originally used.

Get started today by downloading a free trial or attending one of our demonstration webinars.

15-Day
Free Trial