[email protected] +1.303.779.0344

Pipeline Portfolio Timeline

This timeline shows a portfolio of key milestones across several candidates in a biopharma's company's pipeline. The timeline was created in OnePager using data from Planisware, and can also be created using a Project Online or Smartsheet project.

Timeline of key milestones across multiple clinical trials in a drug company's portfolio.


Download Pipeline Portfolio Timeline as PDF      Download Pipeline Portfolio Timeline as Image


OnePager Pipeline Portfolio Components

This timeline features:

  • Zooming in on the second year to give focus to near-term milestones.
  • Assignment of a unique color and shape to each type of milestone (FPI, LPI, LPO, etc.)
  • Displaying the due date for each milestone along the timeline.
  • Placing milestones for each candidate in a single line, on top of a bar depicting the overall project duration.

This pipeline portfolio timeline was created using OnePager, the leading pharmaceutical PPM reporting application for Project Online, Smartsheet, and Planisware.

To learn more about how OnePager can help you build timelines of the key milestones for your company's pipeline, get started today by downloading a free trial.

15-Day
Free Trial

Sample Files

This pipeline portfolio timeline was built using the following files, which you can download to create something similar:

Microsoft Project Samples

Pipeline Portfolio Timeline.mpp (Microsoft Project Plan)

Pipeline Portfolio Timeline (Project).tat (OnePager Template for Microsoft Project)


Microsoft Project Instructions

To build a pipeline portfolio timeline like the example above, follow these instructions:

  1. Download the sample files listed above. The Microsoft Project file contains the portfolio milestones, and the matching OnePager template file has most of the settings that drive the look and feel of the Gantt chart based on the data from Microsoft Project. Save both files to your desktop.

  2. Open the Microsoft Project plan.

  3. Once the project plan is open, go to Add-Ins and click the OnePager button.

  4. When the start screen appears, click NEW to build a new chart.

  5. Change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains most of the data-driven formatting (colors, layout, etc.) that give this Pipeline Portfolio Timeline its specific look.

  6. With the template loaded, click on Create New Chart to build your chart. It should closely match the example at the top of this article.

15-Day
Free Trial

Smartsheet Samples

Pipeline Portfolio Timeline (Smartsheet).xlsx (Excel for import into Smartsheet)

Pipeline Portfolio Timeline (Smartsheet).tat (OnePager Template for Smartsheet)


Smartsheet Instructions

To build a pipeline portfolio timeline like the example above, follow these instructions:

  1. Download the sample files above. The Excel file contains all of the pipeline milestones, and will be imported into your Smartsheet account, while the OnePager template will help define the layout of the timeline itself. Save both files to your desktop.

  2. To import the Excel file into Smartsheet, first log into your Smartsheet account.

  3. In Smartsheet, click on + Solution Center, and then on the Import screen, choose Microsoft Excel:

    Import from Excel into Smartsheet

  4. Point Smartsheet to the Excel file that you downloaded above and press Continue. On the Import Settings, review the name of your sheet, and then click Import::

    Finish importing from Excel into Smartsheet

  5. Now that the sample project has been imported into your Smartsheet account, go to your desktop, and click the OnePager button.

  6. On the OnePager start screen, click NEW to build a new timeline.

  7. Go to Select > BROWSE Smartsheet, log into your Smartsheet account, and then point OnePager to the example project.

  8. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that make the timeline look the way that it does.

  9. Once the custom OnePager template is selected, click on Create New Chart to build your timeline. It should look like the example at the top of this article.

15-Day
Free Trial

Planisware Enterprise Samples

Pipeline Portfolio Timeline.xml (XML for import into Planisware Enterprise)

Pipeline Portfolio Timeline (Planisware).tat (OnePager Template for Planisware Enterprise)


Planisware Enterprise Instructions

To build a Pipeline Portfolio Timeline like the example above, follow these instructions:

  1. Download the sample files above. The XML file contains all of the key milestones (FPI, LPI, LPO, etc.) for each of the candidates, and will be imported into your Planisware account, while the OnePager template will help define the layout of the timeline itself. Save both files to your desktop.

  2. To import the XML file, log into your Planisware account, and create a new project.

  3. In Planisware, locate the menu on the right-hand side of the screen, and then click on the Import button:

    Import from Project XML into Planisware

  4. Click the Search for... button and browse to the XML file that you downloaded. For the Format, be sure to specify MSP (xml), and then click Import::

    Finish importing from Project XML into Planisware

  5. Now that the sample project has been imported into your Planisware account, go to your desktop, and click the OnePager button.

  6. On the OnePager start screen, click NEW to build a new timeline.

  7. Go to Select > BROWSE Planisware Enterprise, log into your Planisware account, and then point OnePager to the example project.

  8. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that make the timeline look the way that it does.

  9. Once the custom OnePager template is selected, click on Create New Chart to build your timeline. It should look similar to the example at the top of this article.

15-Day
Free Trial