In this topic, John Riopel, add graphs to a second worksheet and renames each worksheet in the project dashboard report.
- View Offline
- [Voiceover] You may want to expand…on your data set that you currently have saved.…Now, I'd like to expand out the project name…and to get the next level of my summary.…So I'm going to click on that…and you might get an error message like this one.…A pivot table report cannot overlap…another pivot table report.…If you get that information,…you need to insert some additional rows…to give that pivot table enough room to expand.…So I'm going to click on that three rows…and insert,…I'll repeat that by using my control y keys…to insert three more rows.…
I can now expand out that section of my table.…Now, you may also want to have…other information available to you,…so I'm going to collapse that up…because I don't really need those extra rows here…in this data set.…So, I'll delete those.…And again, if you try to expand that on any selection…and you get that message…you might need to add in some additional areas.…Now I also want to filter this data set…so I'm going to select one of the filters…that I've already built in…
NOTE: This course was designed in collaboration with Bonnie Biafore. The techniques shown work equally well with Microsoft Project 2010, 2013, and 2016.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Using existing report templates
- Creating new visual report templates
- Building a task burnup report with an Excel pivot table and graph
- Building a WBS report with Visio pivot diagrams and filters
- Developing a dashboard report with multiple datasets