From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create and modify PivotCharts
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Create and modify PivotCharts
- [Instructor] Once you've created your PivotTable, the next logical step is, well, let's create some PivotCharts. In this video, we're going to create a PivotChart from a PivotTable we created earlier. Then, we'll format our PivotChart. I'll show you how easy it is to filter the information with the built-in filters, as well as how you can Slicers to your PivotTable and PivotChart. The last thing we'll look at is how to create a custom template of your PivotChart. These are all topics that may be covered on the Excel 2016 MOS Expert Exam. So we'll review each of them, and I'll make sure to focus on the ones you may encounter on the exam. I have the O5O6 exercise file open, so let's create some PivotCharts. We're going to work first, with our 2016 sales data. We have our Products as our Rows. And then, in the Column, we have Region and Location. And the Values are the Sum of the 2016 Sales and the Sum of the 2017 Sales. Well, I'd like to go ahead and shorten the names of each of these…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.