sales@chroniclegraphics.com +1.303.779.0344

Make a Gantt Chart in Excel with OnePager Express

How to make a schedule in Excel quickly and easily

If you've ever been asked to present a project plan or a Gantt chart, you may have created a list of tasks or milestones in Excel and then tried to graph them into a Gantt chart.

After a lot of effort, you may end up with something like this:

Creating Gantt charts in Excel is difficult, and doesn't create impressive results.

The chart above looks terrible! It's also really inflexible, because you can't:

  • Color code different tasks and milestones
  • Reorder or reposition tasks on the screen
  • Format your Gantt chart in Excel to meet your needs


If you want to create professional-looking Gantt charts in Excel without the hassle, you need to use OnePager Express from Chronicle Graphics instead. Download a free trial to get started.


How to create a Gantt chart in Excel with OnePager Express

OnePager Express, a Microsoft Excel add-in from Chronicle Graphics, takes your schedule data from Microsoft Excel and builds professional Gantt charts in seconds. Here's how to make a Gantt chart in Excel in 5 easy steps:

  1. Begin by building a project schedule in Excel. You'll want to have a column for Task Name, Start Date, End Date, and (optionally) Percent Complete for each task. These columns can be named anything you want and can be located anywhere in your Excel spreadsheet:

    Create a Gantt chart using simple Excel columns.

  2. Go to Excel's Add-Ins tab and click the OnePager Express button. Don't have OnePager Express? Download a free trial now.

    Click the OnePager Express button to create a Gantt chart from Excel.

  3. Next, you'll be prompted to give your Gantt chart a name (Project View) and status date (Snapshot Date). Click the Next button.

    Select the tasks for your Excel Gantt chart.

  4. Now, you have the opportunity to map your Excel columns to OnePager Express. The only required columns are Task Name, Start, and Finish. You can map these fields to any column in your Excel spreadsheet, or just go with the default selections that OnePager Express picks for you. When your columns are selected, click Create New Project View.

    Map your Excel spreadsheet columns to a Gantt chart.


  5. In a matter of seconds, OnePager Express will import your schedule from Microsoft Excel and create a full-color Gantt chart just like this:

    Excel Gantt chart created in OnePager Express.


Now you've seen how to make a schedule in Excel with OnePager Express. It's that easy! Out of the box, OnePager Express allows you to:

  • Create full-color Gantt charts using Excel data
  • Save time and frustration over tedious Excel stacked bar charts
  • Customize your Gantt chart in Excel to meet specific needs


OnePager Express is a great way to quickly and painlessly create professional Gantt charts in Excel.

To learn more about how to create a Gantt chart in Excel, you can read some of our other how-to pages. Or get started today by downloading a free trial or attending one of our demonstration webinars, where we will be happy to walk through how to create a schedule in Excel, step by step. 15-Day
Free Trial