Add Timeline Data to Microsoft Project Custom Reports
Question details
The user wants to include timeline information in a custom Microsoft Project report.

- 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.
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.
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.
In Microsoft Project, select View and choose Gantt Chart or another task view.
On the View tab, select the Timeline check box to display the Timeline above the task view.
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.
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.

Copy the Timeline to Excel for Report Formatting
Use Excel when you need more flexibility to arrange a timeline alongside other report information.
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.

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.




