Excel Project Timelines

How to create a timeline for a project plan in Microsoft Excel using OnePager Express


Using Microsoft Excel is a quick and easy way to manage one or many project schedules. However, creating presentations and reports for project plans kept in Excel can be very time-consuming, and the reports don't always look that good.

OnePager Express is an add-in for Excel that allows you to create timelines, Gantt charts, and project reports all based on your existing Excel spreadsheet. This article will show you how, and you can download a free trial to follow along.

  1. Start with your Microsoft Excel schedule. OnePager Express can use any kind of Excel spreadsheet for the schedule, so yours doesn't have to look identical to the one below, but it's a good starting point:

    Project plan tracked in an Excel spreadsheet.

    This spreadsheet contains a column for the task name, start date and finish date. Optionally, you can add information about the phase of the project, resources, progress, and even a filter to select which tasks from the spreadsheet you want to include in your timeline.

  2. Click the OnePager Express button on your Excel toolbar or Add-ins tab to launch the easy import wizard:

    OnePager Express imports project plans from an Excel spreadsheet to create easy timelines.

    We'll give our timeline a name, and specify a snapshot (status) date so that we can make revisions later.

  3. Click the Next button on the wizard to choose which columns from Excel you would like to import:

    Map any column from your Excel spreadsheet into a custom OnePager Express timeline.

    If you use standard names for the columns in your spreadsheet, OnePager Express will guess them automatically for you. However, you can always choose to import a different column than the one that OnePager Express suggests.

  4. Next, click the Create new project view to import your schedule into OnePager Express. You'll automatically get a timeline like this:

    How to create a project timeline in Excel using OnePager Express, an Excel add-in.

    OnePager Express automatically grouped the timeline into swimlanes by the category in the Excel spreadsheet, and color-coded each task based on the resource assignment. This is the default view, but can be customized to fit any kind of format you need.

  5. Just like PowerPoint, you can change fonts, colors and layouts in your OnePager Express chart. Once you're ready to share it, it's easy to copy and paste into PowerPoint or into an e-mail to your colleagues.


OnePager Express is the easiest way to build project timelines, Gantt charts, and schedule reports if you are managing your projects using an Excel spreadsheet.

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

© 2005-2014 Chronicle Graphics, Inc. | Privacy Policy | Sitemap | Contact Us