OnePager connects to Excel to help you build hourly project timelines:
OnePager can also be used to build hourly Gantt charts from Excel, if that's what you are looking to do instead of a timeline.15-Day
How it Works
- Begin with your Excel project schedule. If you're using Microsoft Project instead of Excel, please read these instructions instead. Notice that all tasks start and finish on the same day, but are scheduled at different times:
We've provided two sample files that you can save to your desktop or your downloads folder. The Excel file contains the task and timestamp information, and the *.tat file is the OnePager template that will drive the formatting of the hourly timeline that you're about to create. Please download BOTH files before moving to the next step.
- Import your project plan by clicking the OnePager button on Excel's Add-Ins tab. Don't have OnePager? You can download a free trial.
- On the start screen, click NEW to start creating a new project timeline, then select the "Hourly Timeline" template. Do this by clicking Change > BROWSE FILES and then navigating to your desktop or downloads folder where you saved the template file in the first step.
- Finally, click the Next button, followed by Create New Chart button to create your hourly project timeline from Excel:
This Excel hourly project timeline features:
- All activities aligned left-to-right in a single timeline layout instead of a Gantt chart/waterfall layout
- A unique color for each task, or each type of task
- Text reflecting the name of each task
- A detailed time axis showing the date, hour, and quarter hour. These units can be adjusted as needed if you want to show more or less time detail.
OnePager is the best way to create a project timeline with details down to the hour, down to the minute, or even down to the second. OnePager connects easily with MS Project or Excel, so you don't need to build a timeline from scratch if you already have your project plan in another application.
Get started today by downloading a free trial, complete with our world-class support.15-Day