OnePager Express, presentation software for Microsoft Excel, provides an excellent way to create and maintain Gantt chart presentation slides. If you don’t already have OnePager Express, you can download a 15-day free trial to see how it works.
Just follow these steps and we will show you how to create the initial chart in OnePager Express and how to create periodic snapshots over the course of your project:
- Open your Microsoft Excel project schedule. Make sure that you’ve inserted a flag column (as shown below) to filter which tasks and milestones you want to include in your OnePager Express Gantt chart:
In the example above, any tasks with the “Show it” field set to “Yes” will be included in the Gantt chart.
- Now just double-click the OnePager Express icon on your desktop. From the Start screen that appears, choose New. Choose your Excel spreadsheet as the source file for your Gantt chart. Then, give your Gantt chart a name and type in a status/snapshot date as shown below:
- Now click the Create new chart button, and OnePager Express will create a Gantt chart like this:
Note the dotted line on the Gantt chart that corresponds to the snapshot date you specified earlier. This is an easy way to illustrate the current status date of your project’s schedule.
- Later on in the project, after you’ve updated your Microsoft Excel file with the latest status of your project, you are ready to create an updated snapshot of the project. To do this, simply relaunch OnePager. This time, from the Start screen, choose Update, and select your saved chart as the file to refresh. Then add a new snapshot date as shown below:
Now, click the New button.
- The snapshot below was taken one month from the previous snapshot above:
Note how the project has changed over time. The timeline cursor moved, the percent complete (yellow bars) are updated, and several start and finish dates are repositioned as well. These changes are refreshed on the Gantt chart based on modifications (i.e., updated status data) made to the underlying Microsoft Excel schedule. Assuming that you’ve been making snapshots with OnePager Express throughout the project periodically, OnePager Express will store them so that you have a complete Gantt chart history of your project from start to finish.
- Now, let’s say that you want to build a presentation slide. On the OnePager toolbar are two buttons that allow you to go back to a previous snapshot or forward to a more recent snapshot. These buttons are shown on the OnePager View tab below:
- OnePager Express charts are very easy to share with other people on your team. When you’ve accessed the snapshots you want, it is easy to copy and paste the snapshots into a Microsoft PowerPoint or Word document or even to send the Gantt charts in an email.
OnePager Express is extremely useful for conducting schedule conversations during a project’s lifecycle. Also, OnePager Express' ability to take snapshots during a project enables project managers to monitor the actual schedule visually against the baseline and prepare clear and accurate schedule slides for project status presentations.15-Day