[email protected] +1.303.779.0344

Home How-To

Make a Gantt Chart from an Excel 2010 or 2013 Project Plan

How to use OnePager Express to create an Excel schedule and then share it in PowerPoint

It's easy to manage simple projects in Excel, as long as you can find a way to communicate the schedule to everyone else on your team. OnePager Express, an Excel add-in, makes it easy to create a Gantt chart in Excel 2010 or Excel 2013, and then share it with your team in PowerPoint.

Excel project plans: A Gantt chart of an Excel schedule, ready to share in PowerPoint, created in the OnePager Express add-in.

15-Day
Free Trial

If you don't have OnePager Express, you can download a free trial and follow these step-by-step instructions to build an Excel schedule view:

  1. Build a simple project plan in Excel. In this example, we have a separate row for each task, with a start and finish date. We also specified which phase of the project the tasks belong to:
    Simple project schedule kept in an Excel spreadsheet.
  2. Double-click the OnePager Express icon on your desktop. From the Start screen that appears, choose New.
    OnePager Express Start screen.
  3. Choose your Excel spreadsheet as the source file for your project timeline.
    OnePager Express source file selection.
  4. OnePager Express will launch an easy import wizard. Give your Excel schedule a name, and specify a snapshot (status date) as shown below:
    Import your Excel project plan into OnePager Express.
  5. Click Next and double-check that the columns you're importing from Excel are the ones you want in your Excel project plan:
    Import your Excel project plan into OnePager Express.
  6. Click on the Create new chart to build a summary of your Excel schedule, and customize the look and feel if you'd like:
    Excel project plans: A Gantt chart of an Excel schedule, ready to share in PowerPoint, created in the OnePager Express add-in.
  7. You now have an eye-catching Gantt chart from Excel that you can share with the rest of your team. Just go to Home > Copy, and paste your chart into PowerPoint.

Customizable

It's really easy to get started! The best part is that you can customize your OnePager Express report to:

  • Change colors, symbols, and fonts with conditional formatting
  • Automatically group tasks into swimlanes by resources, project phase, or any other Microsoft Excel data
  • Update your report (without starting over) any time your Excel project plan changes
  • Add comment boxes, text boxes, curtains, or images to your Gantt chart in Excel

OnePager Express is the easiest way to make PowerPoint-ready project plans in Excel. Join the thousands of people just like you who use OnePager today!

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

15-Day
Free Trial