After a lot of effort, you may end up with something like this:
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:
-
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:
-
Go to Excel's Add-Ins tab and click the OnePager Express button. Don't have OnePager Express? Download a free trial now.
-
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:
-
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.
-
In a matter of seconds, OnePager Express will import your schedule from Microsoft Excel and create a full-color Gantt chart just like this:
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.
15-DayFree Trial