OnePager works with Microsoft Project or Excel to create Gantt charts that accurately distinguish working and non-working hours. This feature is available in version 6.1, beginning in late 2018:
Download a free OnePager trial and get started with these simple steps:
Create a Basic Gantt Chart
- Click on the OnePager button:
- When the OnePager start screen pops up, click NEW to build a new Gantt chart, and then point OnePager to your project plan. In this case, we're using an Excel spreadsheet, but you could use a Microsoft Project file as well:
- The import wizard will ask you a few questions about how to build your Gantt chart. You can take the defaults the first time around, and just click on Next, followed by Create New Project View:
- The initial Gantt chart shows a 24-hour clock and shows weekends, meaning that is showing both working hours and non-working hours. This is NOT what we want:
Use Different Colors for Working Hours and Non-Working Hours
One option is to highlight working and non-working hours differently so that it's clear when work is taking place and when it isn't. To do this:
- With your OnePager Gantt chart open, go to Home > Project View Properties > Time Axis > Format. OnePager lets you assign a different color to non-working hours, so we'll pick gray in this case:
- Click OK, and your Gantt chart will now show your working hours as white, with your off-hours as gray:
Only Show Working Hours
Your other option is to hide all non-working hours (overnights and weekends) so that only working hours show in the Gantt chart. To do this:
- Go to Home > Project View Properties > Time Axis > Format. Uncheck the Show Non-Working Hours box:
- We can then change our time axis units to show each working hour, instead of every three hours as we had before. Move from the Format sub-tab to the Bottom Level sub-tab, and change your hourly units so that each hour is shown:
- You can also stretch the width of your chart a bit now that so many non-working hours have been removed, making the remaining working time more readable. The end result looks like this:
OnePager is the most direct way to create a budget report out of a Microsoft Project plan. Because OnePager Pro is a reporting app, it gives you all of the power of MS Project with the visual capabilities of PowerPoint.
Get started today by downloading a free trial or attending one of our demonstration webinars.
15-DayFree Trial