How to Add Weekly Resource Totals to a Microsoft Project Gantt Chart
Question details
The user wants to display and print weekly resource totals alongside a Gantt Chart on the same page in Microsoft Project.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Reviewing project resource allocations on a weekly timescale and attempting to present this data together with the project's Gantt chart.
- Observed behavior
- Microsoft Project lacks a built-in feature to print both the Gantt chart and the resource weekly totals on the same page simultaneously, forcing them to be printed separately.
Ensure your project file has resources properly assigned to tasks and that your timeline spans multiple weeks so the resource data can correctly populate across the weekly timescale.
Create a Split View and Print Separately
Since Microsoft Project cannot print split views on a single page out-of-the-box, the most effective workaround is to analyze the data using a split view on your screen, and then print the Gantt Chart and Resource view separately.
Microsoft Project treats different view panes as separate printing entities. To get the data you need for a report or presentation, you must configure both views to use a synchronized timescale and then print them one by one.
Go to the 'View' tab on the ribbon and check the 'Details' box in the Split View group. This will divide your screen into top and bottom panes.
Click anywhere in the bottom pane to make it active. Go to the 'View' tab and select 'Resource Usage' or 'Resource Graph' from the Resource Views group.
Right-click the timescale header in both the top Gantt Chart and the bottom Resource view. Select 'Timescale', navigate to the Middle or Bottom Tier tab, and change the 'Units' drop-down to 'Weeks'.
Click on the top pane to ensure the Gantt Chart is active. Go to 'File' > 'Print' to format and print your Gantt Chart.
Click on the bottom pane to activate the Resource view, then go to 'File' > 'Print' to print your weekly resource totals.

Manage Project Schedules Easily with WPS Office
While Microsoft Project is built for heavy-duty resource leveling, you can easily build, track, and print custom Gantt charts along with resource tables using WPS Spreadsheet. WPS Office offers a lightweight, free alternative to Microsoft Office that gives you full control over page layout and printing.
- 1. Download and open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet document.
- 2. Select a Gantt Chart template: Click on 'Templates', search for 'Gantt Chart', and select a template that includes resource tracking.
- 3. Customize and print: Input your weekly resource totals next to your chart. Go to 'Print Preview' to easily scale and print both the chart and your resource data on one page.

Frequently Asked Questions
Can I export Microsoft Project views to Excel to print them together?
Yes. You can use the 'Visual Reports' feature under the Report tab in Microsoft Project to export resource usage and task data directly to Excel. Once in Excel, you have complete freedom to format, arrange, and print both the data and the charts on a single page.
Why doesn't Microsoft Project print the split view exactly as it appears on my screen?
Microsoft Project's printing engine processes the active view pane independently. It does not support 'what you see is what you get' (WYSIWYG) printing for split-screen layouts, meaning whichever pane you clicked on last is the one that will be sent to the printer.
How do I change the timescale to show weekly totals in the Resource Usage view?
Right-click the timescale header at the top of the Resource Usage view and select 'Timescale' from the context menu. Under the Middle Tier or Bottom Tier tab, change the 'Units' to 'Weeks' and click OK.




