Excel Gantt Charts

Making project plans and schedules in Microsoft Excel

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:

Once you've started playing with your Excel Gantt chart, you may have noticed that it was difficult to:

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

If you want to create professional-looking project schedules in Excel without the hassle, consider using OnePager Express from Chronicle Graphics instead.

Enhancing your Excel schedule 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:

Begin by building a project schedule in Excel. You'll want to have a column for Task Name, Start Date, and End Date. 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 project a name (Project View) and status date (Snapshot Date). By default, you can use the name of your Excel file and today's date. For Task Selection, you can leave the Select All Tasks button selected. 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:

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 to meet specific needs

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

Get started today by downloading a free trial or attending one of our demonstration webinars.