Creating and modifying a PivotChart


show more Creating and modifying a PivotChart provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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. L...

Creating and modifying a PivotChart
Video duration: 5m 56s 6h 21m Beginner

Viewers:

Creating and modifying a PivotChart provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...