This topic covers inserting the graphing display which includes using data labels, line elements, working with legends, and filters. We also move the graph to a separate worksheet.
- [Voiceover] We've created our BurnUp report so far.…We want to add and enhance that report…by adding some additional functions into it.…Since we're not really interested in this…detail level task item here,…we'll collapse that task once…and bring that up to a higher level.…We're also interested in renaming that particular data sheet…so we're going to right-click on it…and rename that to data.…Now, we want to insert a graph…of this particular report,…so we'll going to select the whole chart…and we're going to go to the insert ribbon…and select under the 2-D options…we'll select the 2-D line chart.…
Now I would like this to be a whole page,…so we're going to Ctrl-X, or cut that…and we'll add a new sheet and paste that in.…Now that we've added in our new graph,…we've connected the two items together.…Our data sheet and our chart,…so we're going to right-click on the sheet number one now…and rename that to our chart.…So we've created our first step into our BurnUp report…which is a lot more enhanced than out of the box.…
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.