From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Create and modify PivotCharts

Create and modify PivotCharts

From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep

Start my 1-month free trial Buy for my team

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