To have a PivotChart you first have a PivotTable, and is another way to analyze data in your Excel 2007 program. The PivotChart allows you to pivot, or filter between selected data and being able to quickly chart it. You can also format the PivotChart and also chang the Chart's type: Pie chart, Column chart, Bar chart, Line chart etc. You can either create a PivotTable first and then create your PivotChart, or create your PivotChart but keeping in mind it will automatically create a PivotTable as it is based upon it. Once the PivotChart has been established through the wizard, then it's simply a matter of choosing the appropriate data to add to it.

Purchase the training video and you can see this in action for yourself!