[email protected] +1 303 779 0344

Home Examples By Industry BioPharma

Clinical Trial Milestone Timeline

This timeline shows key milestones across the multiple clinical trials in a biopharma company's portfolio. The timeline was created in OnePager using data from Microsoft Project, and can also be created using a project from Planisware or Smartsheet.

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

Download Clinical Trial Milestone Timeline as PDF      Download Clinical Trial Milestone Timeline as Image

OnePager Milestone Timeline Components

This timeline uses:

  • Alignment of key milestones for each compound into a single row
  • Grouping of compounds into swimlanes based on project (candidate) and then into a second set of swimlanes based on the subproject.
  • Specific symbols and colors for each type of milestone, for consistent reporting across trials
  • Display of key milestone dates along the timeline

This clinical trial milestone timeline was created using OnePager, a leading portfolio timeline application for Microsoft Project, Smartsheet, or Planisware.

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

15-Day
Free Trial

Sample Files

This clinical trial milestone timeline was built using the following files, which you can download if you'd like to create something similar

Microsoft Project Samples

CTR 5667 YPF.mpp (First Microsoft Project Plan)

DC 9000 Big TX.mpp (Second Microsoft Project Plan)

Clinical Trial Milestone Timeline (Project).tat (OnePager Template)


Microsoft Project Instructions

To build a clinical trial milestone timeline like the example above, follow these instructions:

  1. Download the three sample files listed above. There are two Microsoft Project files and one OnePager template file. Save all three files to your desktop.

  2. Open one of the two Microsoft Project files.

  3. Once Microsoft Project is open, go to Add-Ins and click the OnePager Pro button.

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

  5. On the import wizard, you should see that the first Microsoft Project plan has already been imported. Click Add/Remove to add more files. When the second window appears, click Add and then BROWSE FILES to add the second Microsoft Project file from the set of examples:

    Import multiple Microsoft Project files

  6. With both Microsoft Project ready for import, 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 (colors, layout, etc.) that give this timeline its specific look.

    Use a Custom OnePager Template

  7. With the two Microsoft Project files ready and the custom OnePager template selected, 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

Clinical Trial Milestone Timeline (Smartsheet).xlsx (Excel for import into Smartsheet)

Clinical Trial Milestone Timeline (Smartsheet).tat (OnePager Template for Smartsheet)


Smartsheet Instructions

To build a clinical trial milestone timeline like the example above, follow these instructions:

  1. Download the sample files above. The Excel file contains all of the key milestones for each clinical trial, 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 + Start a New Project, and then from the Import tile, 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 similar to example at the top of this article.

15-Day
Free Trial