From the course: Excel 2010 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Creating and modifying a PivotChart - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Creating and modifying a PivotChart
Even though PivotTables do a great job of slicing, dicing, and baking your data so many different ways, sometimes you will get the clarity you need only by looking at a PivotChart. Now, there are two ways that you can create a PivotChart and I will show you both ways. One is you can take an existing PivotTable and make a chart out of it. The other way is to skip the middleman. Create a PivotChart directly from your underlying data without having to create a PivotTable first. Well, let's do the first method first. We already have a PivotTable here. And if you want, you could go down and click the Data tab just to see the underlying data. I will click back on the PivotTable tab. And make sure you click somewhere in the PivotTable. It doesn't really matter where. Now, up here on the Ribbon bar, you have the PivotTable Tools section. And select the Options tab, and over here click PivotChart. And this will let us insert a chart. And you have so many different types of charts you can use…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.