sales@onepager.com +1.303.779.0344

Hourly Gantt Charts in Excel

Create hourly project Gantt charts with Excel and OnePager Express

If your organization manages simple projects in an Excel spreadsheet, you can use the free trial of OnePager Express to build a Gantt chart with details down to the hour, minute, and even second. This article will walk you through how it works.

OnePager Express builds hourly Gantt charts like these using data from a simple Excel spreadsheet:

Hourly Gantt Chart from Excel.

OnePager can also create hourly project timelines from Excel instead of the Gantt chart layout, if that's more of what you need.

Here's how to build an hourly Gantt chart from your Excel spreadsheet:

  1. Download the free trial of OnePager Express and install it before following these instructions.

  2. In the example below, we have a simple project plan in Excel, consisting of a start time and finish time for each task:

    Hourly project plan in Excel.

    You can build a spreadsheet like this from the ground up, or you can download our example spreadsheet as a starting point and modify it to fit your own project. Just make sure that each line in the spreadsheet has its own Unique ID and that your start and finish times specify BOTH the date and time, just in case your project ends up spanning more than 24 hours.

  3. To import your Excel project plan into OnePager, go to the Add-Ins tab of Excel and click the OnePager button:

    OnePager Express Excel Add-In.

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

  5. On the import wizard, select the Hourly Gantt Chart template as your starting point. If you don't have it already, you can download it here. Save it to your desktop first (don't open it). Once saved to your desktop, use the BROWSE FILES option in OnePager Express to open the template file from your desktop, like this:

    Import the custom hourly Gantt chart template.

  6. Click Next > on the import wizard to make sure that the different fields from Excel look like they're going to the right place, and then click Create New Project View to import all of your information from Excel and build a first draft of your hourly Gantt chart.

  7. OnePager will combine the data from your spreadsheet with the settings from the template to give you an hourly Gantt chart that looks like this:
    Hourly Gantt Chart from Excel.

Once you've built your hourly Gantt chart, you can change colors, layouts, and other formatting options before saving it to PowerPoint or PDF to share with the rest of your team. OnePager charts are completely customizable, so if you need help getting your OnePager hourly Gantt chart to look just the way you want it, please reach out to us at support@onepager.com.

OnePager Express is the easiest and most flexible way to build hourly Gantt charts from Excel. Get started today by downloading a free trial, which includes our world-class support if you need it.

15-Day
Free Trial