Learn how to sort and filter data in a PivotChart. Author Jen McBee demonstrates how to use the field buttons to sort and filter data in the PivotChart, and how to use Slicers to filter data in the PivotChart.
- [Voiceover] In this video, we are going to take a look…at the options available to you…when you're working with PivotCharts.…I'll show how you can…show and hide the PivotTable field list.…Sometimes when that field list is visible to you,…it takes up part of your desk top space.…So, I'll show you how you can hide it;…so, you have extra work space available to you.…I'll also show you how you can switch the fields…for your axis and your legend.…We'll look at how to use filters…to drill down into our information.…
And also, how you can use slicers to filter the information.…Slicers are really fun and cool to work with.…Let's jump into our 05.02 PivotChart Options work book.…This is the chart that we created in the previous video.…Let's go to our 2017 sales worksheet.…This is our PivotTable that's been created.…And, you'll notice over on the right-hand side,…you cannot see the field list.…If I go back to Analyze on the right-hand side…in my Show Group, this is how I can turn that on and off.…
By clicking the Field List,…
Author
Jennifer McBee
Released
5/4/2017Lynda.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. In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.
- Using templates
- Managing versions
- Leveraging macros
- Linking to external data
- Protecting cells
- Hiding formulas
- Using advanced Fill Series options
- Creating form fields
- Using advanced functions: AND/OR, SUMIFS, AVERAGEIFS, and COUNTIFS
- Manipulating options in existing PivotCharts
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Microsoft Office Specialist (MOS) Expert Exam Overview
-
2. Manage and Share Workbooks
-
Create and modify templates4m 15s
-
Link to external data6m 51s
-
-
3. Apply Custom Formats and Layouts
-
Create form fields5m 1s
-
4. Create Advanced Formulas
-
Use a Nested IF function3m 54s
-
Use the AND/OR functions6m 21s
-
Use financial functions3m 24s
-
-
5. Create Advanced Charts and Tables
-
Create new PivotCharts3m 39s
-
Apply styles to PivotCharts4m 20s
-
-
6. Sample Exam
-
Conclusion
-
Next steps30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Manipulate options in existing PivotCharts