[email protected] +1.303.779.0344

Create a Gantt Chart in Excel with OnePager Express

How to make a Gantt chart 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 make 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 create 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 ID, 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. On the start screen, click New to start building a new Excel Gantt chart. On the import wizard, give your chart a name, and then click Next again:

    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, Finish, and Unique ID. 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 Chart.

    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 make a Gantt chart in Excel, you can read some of our other how-to pages. Or get started today by downloading a free trial.

Free Trial