Creating a PivotChart


show more Creating a PivotChart provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Creating a PivotChart

You not only can create a Pivot Table from your data, but you can create a Pivot Chart. And you could do that by going up to your Insert tab, going to Pivot Table and instead of selecting Pivot Table directly from here, you would select PivotChart. Selecting the PivotChart brings out that the very familiar Screen dialog box that helps you create a regular chart. You will identify the table range that you're working with as well as where you would like to store this new worksheet, You'll click on this, and again, you'll be brought into your Pivot Table area, as well as you see a new PivotChart Filter Pane which allows you to identify what you are going to have as active fields on your PivotChart.

Let's first create some of the PivotTable itself, so we're going to look at Flour, and the Icing sugar, Mix, Sprinkles and Toppings which are our Item Categories, and we're going to look at final costs. So, we want to see which of our different categories are costing us the m...

Creating a PivotChart
Video duration: 3m 25s 5h 13m Beginner

Viewers:

Creating a PivotChart provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...