From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
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 Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create and modify PivotCharts
- [Instructor] In this video, we will take a look at how to create a new PivotChart and how to modify an existing PivotChart. We'll create our PivotChart and then I'll show you how you can manipulate options in your new chart and in the existing PivotCharts. We'll add a style to our chart and I'll show you how to drill down into the PivotChart details. Let's jump into our PivotCharts workbook. We do already have a PivotTable created and a chart linked to our data. This would be much easier to see if we moved it to a new worksheet. I'll go to my PivotChart tools, Analyze, and choose Move Chart. Move it to a new sheet. I have the opportunity to rename my chart sheet, so I'm going to take advantage of that. 2019 Sales, and I'll call it PC for PivotChart. Ah, that's a little easier to read. Now we are seeing the data by order date. It might be easier to analyze our data if it's by month. So let's go over to our…
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.
Contents
-
-
-
-
-
-
-
(Locked)
Create and modify dual-axis and combo charts2m 47s
-
(Locked)
Create and modify box and whisker and funnel charts5m 55s
-
(Locked)
Create and modify histogram and map charts6m 27s
-
(Locked)
Create and modify sunburst and waterfall charts6m 39s
-
(Locked)
Create and modify PivotTables7m 44s
-
(Locked)
Create and modify PivotCharts6m 5s
-
(Locked)
Challenge: Manage advanced charts and tables28s
-
(Locked)
Solution: Manage advanced charts and tables5m 40s
-
(Locked)
-
-