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
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:
- 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:
- Go to Excel's Add-Ins tab and click the OnePager Express button. Don't have OnePager Express? Download a free trial now.
- Next, you'll be prompted to give your Gantt chart a name (Project View) and status date (Snapshot Date). Click the Next button.
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.
- 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 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.