Others

How to Add Weekly Resource Totals to a Microsoft Project Gantt Chart

Emma BrownEmma Brown Oct 29, 2026 870 views

Question details

The user wants to display and print weekly resource totals alongside a Gantt Chart on the same page in Microsoft Project.

How to Add Weekly Resource Totals to a Microsoft Project Gantt Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Enable the split view

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.

2
Set up the Resource view

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.

3
Adjust the timescale to weekly

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'.

4
Print the Gantt Chart

Click on the top pane to ensure the Gantt Chart is active. Go to 'File' > 'Print' to format and print your Gantt Chart.

5
Print the Resource Totals

Click on the bottom pane to activate the Resource view, then go to 'File' > 'Print' to print your weekly resource totals.

Create a Split View and Print Separately
Alternative Export Method: If you absolutely must have both elements on a single page, consider using the 'Visual Reports' feature to export the task and resource data to Excel, where you can freely arrange and print charts and tables together.
Free Microsoft Office alternative

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. 1. Download and open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet document.
  2. 2. Select a Gantt Chart template: Click on 'Templates', search for 'Gantt Chart', and select a template that includes resource tracking.
  3. 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.
Free, lightweight, and incredibly easy to useSeamless format compatibility with Microsoft Excel (.xlsx) filesAccess to thousands of free pre-built project management and Gantt chart templatesPrint multiple charts, resource tables, and data sets on a single page effortlessly
microsoft office alternative - wps office

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.