Excel PivotTables and PivotCharts Topics

Chapter 7: Working with PivotTable Reports

• A VIEW OF THE PIVOTTABLE REPORT FIELDS
• CREATE A PIVOTTABLE REPORT FROM AN EXCEL LIST
• CHANGE THE LAYOUT OF A PIVOTTABLE
• FILTER A FIELD
• CHANGE THE CALCULATION OF A DATA FIELD
• GROUP PIVOTTABLE DATA ITEMS
• ADD ANOTHER DATA AREA CALCULATION
• ADD A CALCULATED FIELD
• ADD A CALCULATED ITEM
• RETRIEVE A VALUE FROM A PIVOTTABLE REPORT

Chapter 8: Creating PivotCharts

• CREATE A PIVOTCHART FROM AN EXTERNAL DATABASE
• CHANGE THE LAYOUT OF A PIVOTCHART
• CHANGE THE CHART TYPE OF A PIVOTCHART
• FILTER A PIVOTCHART FIELD
• GROUP ITEMS IN A PIVOTCHART FIELD
• ADD A DATA TABLE TO A PIVOTCHART
  

A simple thanks will do.. :)


The requested file is here
Downloads
Excel charts and pivot tables.part1.rar
Excel charts and pivot tables.part2.rar
Excel charts and pivot tables.part3.rar
Excel charts and pivot tables.part4.rar

Working with pivot tables and creating charts

PivotTables provide an excellent tool for quickly analyzing data values from an Excel list or an external database by creating a cross-tabulated summary of the data values. With a PivotTable Report, you can dynamically customize which columns from the list that you want to summarize.






A PivotChart combines the dynamic, cross-tabulation ability of the PivotTable with the visual aspect of a chart. This allows you to dynamically analyze your data values in a chart format and to quickly spot any trend.
Although you can use PivotCharts with data from any source, they are best suited for smaller sets of data, because if you try to show too much data on a chart, it becomes difficult to interpret.