Building a Gantt chart does not require complicated project management software like Microsoft Project. In fact, it's easy to build a simple one from an Excel spreadsheet using OnePager Express Gantt chart software. If you aren't familiar with OnePager Express or Gantt charts in general, download a 15-day free trial to see how easy it is:
These instructions are designed for people don't already have a project plan in Excel. You can use our example Excel project plan as a starting point and follow these abbreviated steps to create your chart in a matter of minutes.
Start by downloading these two sample files to your downloads folder or to your desktop. The Excel file contains the task/milestone data, and the *.tat file is the OnePager template that will drive the formatting of the chart you're about to create.
Open the Excel file that you just downloaded. From Excel's Add-Ins tab, click the OnePager Express button:
On the Start screen, click NEW to begin building a new Gantt chart:
On the next screen, locate the Starting Template section, and go to Change > BROWSE FILES. Browse to your desktop and select the Simple Excel Project Plan.tat that you downloaded in step #1:
With your Excel file loaded and your OnePager template selected, click Next, and then on the following screen, click Create new chart. OnePager will import the data from your Excel file and create a Gantt chart in just a few seconds:
Now that you've done this, you can go back to Excel and adjust the spreadsheet to match the dates and deliverables of your real-world project plan. Once you've done this, follow the same steps again with your updated Excel sheet, and you'll be well on your way!
These instructions are designed for people who have already built a project plan in Excel and need to import what they already have into OnePager. These instructions also provide more details about customization along the way.
Launch your Excel Gantt chart software by double-clicking the OnePager Express icon on your desktop:
From the start screen, click NEW to build start building your Excel Gantt chart:
Click Select, then Browse to find the Excel spreadsheet(s) that you want to use for your Gantt chart.
You can use a simple Excel spreadsheet for starters, as long as you list each task, the start date, and the finish date like this:
Name your Gantt chart. You can import everything from Excel, or filter a set of tasks and milestones. In this example, we'll include everything.
Click Next to quickly review the fields you are importing from Excel:
Finally, hit the yellow Create new Chart button to pull in your Excel spreadsheet and create the Gantt chart:
If your Excel Gantt chart looks good as-is, go to File > Save As to export it to PDF, PowerPoint, or another format for easy sharing. If your Gantt chart needs a little touch-up, OnePager Express offer the most layouts and customizations of any Gantt chart software.
Try OnePager Express Gantt chart software today by downloading a free trial, which includes our world-class support.15-Day