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

Create and modify PivotCharts

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

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…

Contents