A Beginner's Guide to Using Visual Reports in Microsoft Project
Article by: Avantix Learning Team | Updated May 16, 2016
Applies to: Microsoft® Project® 2010, 2013 and 2016 (Standard and Professional)
Visual Reports offer a useful alternative for reporting compared to reports created within Microsoft Project. You can export data to both Excel and Visio using Visual Reports. These reports first appeared in Microsoft Project 2007 and are available in Project 2010, 2013 and 2016. In this article, we'll focus on getting started with Visual Reports and sending data to Excel using the templates that are shipped with Project.
The obvious benefit of Visual Reports is that data can be sent to Excel. Although many business users have Microsoft Excel installed, significantly fewer have a copy of Microsoft Project. As a result, sharing Project information can present a problem in many organizations. The Visual Reports button appears on the Project tab in the Ribbon in 2010 and in the Report tab in 2013 and 2016.
Below is the Project tab in 2010:
Below is the Report tab in 2013:
When a Visual Report is sent to Excel, both a PivotTable and PivotChart are created for the built-in templates. Once the report has been sent, you can customize it in Excel.
Recommended article: 10 Timesaving Shortcuts in Microsoft Project's Gantt Chart View
Accessing Visual Reports
To access Visual Reports:
- In Microsoft Project, click on the Report tab (2013 and 2016) or the Project tab (2010) on the Ribbon.
- Click on Visual Reports. A Create Report dialog box appears with the default Visual Report templates.
Visual Report templates
The default templates that are shipped with Project appear in the Create Report dialog box and are separated into categories. You can click on a category at the top or click on the All tab to view all report templates and then select the Excel button or checkbox at the top of the dialog box to view only Excel templates.
Excel Visual Report templates include:
- Cash Flow Report
- Earned Value Over Time Report
- Resource Cost Summary Report
- Resource Work Availability Report
- Resource Work Summary Report
- Resource Cost Summary Report
- Resource Work Availability Report
- Resource Work Summary Report
- Baseline Cost Report
- Baseline Work Report
- Budget Cost Report
- Budget Work Report
- Earned Value Over Time Report
- Resource Remaining Work Report
Creating an Excel Visual Report using a template
To create an Excel Visual Report using a template:
- In Microsoft Project, click on the Report tab (2013 and 2016) or the Project tab (2010) on the Ribbon.
- Click on Visual Reports. A Create Report dialog box appears (usually with the default Visual Report templates).
- Ensure that the Excel checkbox at the top of the dialog box is selected.
- Click on the All tab and then click on the report you want to create.
- Select an option from the Select level of usage data drop-down menu. You can select Years, Quarters, Months, Weeks or Days. By default, Project sets the level of usage data to a recommended level for the project's size (which is usually weeks). If you change the level of usage to a more detailed level such as days, this may decrease the report performance and slow down the generating of the report.
- Click on View to generate the report and open it in Excel. This may take a minute or two. The Excel report opens with tabs at the bottom of the workbook for a PivotChart and a PivotTable.
Below is the Resource Work Summary report in Excel 2010:
Below is the Resource Work Summary report in 2013:
Editing a Visual Report in Excel
Visual Reports sent to Excel appear in Compatibility Mode in 2010 and later versions and can therefore be read by older versions of Excel (the templates were originally created for 2007). You may want to save the report in the newest Excel format to take advantage of new features such as Sparklines. Eventually, you may even want to save your own templates in Excel.
To edit a PivotChart in a Visual Report in Excel:
- Click in the PivotChart in Excel that was created during the generation of the Visual Report.
- Click on the PivotChart Tools Design, Layout, Format or Analyze tabs (depending on your version of Excel) and choose the desired options to modify the PivotChart.
- Click in the PivotChart Field List and select any fields you wish to add to the PivotChart.
- You may want to click on the File tab on the Ribbon and select Save As, then select Microsoft Excel as the format (if you want to use new features), enter a name for the file and click on Save.
To edit a PivotTable in a Visual Report in Excel:
- Click in the PivotTable in Excel that was created during the generation of the Visual Report.
- Click on the PivotTable Tools Design, Options or Analyze tabs (depending on your version of Excel) and choose the desired options to modify the PivotTable.
- Click in the PivotTable Field List and select any fields you wish to add to the PivotTable.
- You may want to click on the File tab on the Ribbon and select Save As, then select Microsoft Excel as the format (if you want to use new features such as Sparklines), enter a name for the file and click on Save.
In this article, we used existing templates to create Visual Reports. You can also modify a Visual Report template and create a new Visual Report template.
Subscribe to get more articles like this one
Did you find this article helpful? If you would like to receive new articles, join our email list.
Related
Auto vs Manual Scheduling in Microsoft Project
How to Create a Timeline in MIcrosoft Project
10 Shortcuts to Zoom and Move Quickly in the Gantt Chart Timescale
Recommended courses
Microsoft Project: Introduction
Microsoft Project: Intermediate / Advanced
Microsoft Project: Introduction to VBA (Visual Basic for Applications)
Microsoft Excel: Intermediate / Advanced
To request this page in an alternate format, contact us.
Copyright 2022 Avantix® Learning
You may also like
7 Microsoft Project Navigation and Selection Shortcuts in Task Lists
If you are working in Gantt Chart view, you can use these keyboard shortcuts to quickly move and select in your task list.
10 Microsoft Project Shortcuts to Zoom and Move Quickly in the Gantt Chart Timescale
Zoom in, out and move using these great shortcuts in the Microsoft Project Gantt Chart timescale. The timescale in the Gantt Chart view appears on the right side and displays units of time.
Auto vs Manual Scheduling in Microsoft Project
In newer versions of Microsoft Project, you have the option of scheduling tasks using manual or auto scheduling. In earlier versions, Microsoft Project used auto scheduling which takes advantage of Project's scheduling engine to schedule tasks.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca