Learn how to apply styles to PivotCharts. Author Jen McBee demonstrates how to apply Chart Styes, Quick Layouts and how to change the color palette in PivotCharts and create a custom color.
- [Instructor] You apply Styles to your PivotCharts…the same way that you apply your Styles…to your other charts.…In this video we'll look at how to apply…Quick Styles,…Quick Layouts,…how to change the color palette,…and how to create a custom theme color.…We'll also look at how easy it is…to change the chart type.…We'll be using the O503 PivotCharts Styles workbook.…This is a PivotChart that was created earlier,…and when we click on the chart…we have our Chart Tools contextual tabs, Design and Format.…
On the Design tab is where we can find…our Chart Styles, our Quick Layouts,…and where we can Change Colors.…Let's take a look at our Chart Styles.…Click the down arrow in the scroll bar…and we can see the gallery of Styles available.…And as we mouse over each of these,…we can see what that Style would look like if we applied it.…Notice that they are all numbered…from one to 14 sequentially.…So if you're asked on the exam to apply a Style,…just mouse over the Styles…until you find the one that you need.…
Let's look at the Quick Layouts.…
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: Apply styles to PivotCharts