Others

Add Timeline Data to Microsoft Project Custom Reports

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user wants to include timeline information in a custom Microsoft Project report.

Add Timeline Data to Microsoft Project Custom Reports
Product
Microsoft Project
Device & OS
not provided
Scenario
Creating a Project-generated report, such as Project Overview, with timeline information and summary-task dates.
Observed behavior
The built-in report tools provide limited timeline customization, so alternative views or an export may be needed.
Before you start

Open the project and identify the summary-task level you want to report. Check that the tasks have the start and finish dates you need to display.

Solution 1Recommended

Show the Timeline Above a Filtered Task View

Use a split view to see the timeline and selected summary-task dates together in Microsoft Project.

This is a view-based workaround, not a way to insert a live Timeline view into a report on the Reports tab. Built-in reports have limited timeline customization.

1
Open a task view

In Microsoft Project, select View and choose Gantt Chart or another task view.

2
Show the Timeline

On the View tab, select the Timeline check box to display the Timeline above the task view.

3
Create an outline-level filter

On the View tab, open the Filter menu and choose More Filters. Create a task filter using the Outline Level field, an equals test, and the level you want to display.

4
Apply the filter

Apply the new filter to the lower task view. Check the Start and Finish columns for the selected tasks; add those columns to the view if needed.

Show the Timeline Above a Filtered Task View
Choose the right level: An outline level can include both summary tasks and regular tasks. If you need only summary tasks, add a Summary equals Yes condition to the filter.
Free Microsoft Office alternative

Format Project Timeline Reports in WPS Spreadsheet

WPS Office is a free, lightweight alternative for working with spreadsheet reports. Open an Excel workbook containing a copied Project timeline and use a familiar interface to format the surrounding data. WPS Office does not add a live timeline to Microsoft Project reports.

Format spreadsheet reports around a copied project timeline.Open and edit Microsoft Excel XLSX workbooks.Use a familiar spreadsheet interface for an easier transition from Microsoft Office.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Can I insert the Timeline view directly into a Project Overview report?

Microsoft Project's built-in report tools have limited timeline customization and do not provide a direct way to embed the live Timeline view in Project Overview. Use a split view or copy the timeline to a spreadsheet as a workaround.

How do I show only summary tasks at a particular outline level?

In a task view, go to View > Filter > More Filters and create a filter with Outline Level equal to the desired level. Add a Summary equals Yes condition to exclude regular tasks at that level.

Will a timeline pasted into Excel update when my project changes?

No. Copy Timeline creates a separate copy. After changing the project, use Timeline Format > Copy Timeline again and replace the pasted copy in Excel.

Can WPS Office edit my Microsoft Project file?

WPS Office is an alternative for formatting Office documents and spreadsheets, not a replacement for Microsoft Project's project-file editing. You can use WPS Spreadsheet to work with an Excel workbook containing exported data or a copied timeline.