In this topic, John Riopel, add graphs to a second worksheet and renames each worksheet in the project dashboard report.
- [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.
- Explain how to edit a report template.
- Recall how to insert a graph into a visual Excel template.
- Recognize the steps to take in order to add additional functionality into a Visio WBS diagram.
- Determine the steps to expand on a data set in an Excel report.
- Identify three PivotChart tools.