PivotTable reports are used to summarize, analyze, explore and present large amounts of data.  Once a PivotTable is built, use a PivotChart report to visualize the data, and to easily see comparisons, patterns, and trends. Both a PivotTable report and a PivotChart report enable you to make informed decisions about critical data in your enterprise.

A PivotChart report provides a graphical representation of the data in a PivotTable report.   In this class we will cover the basics of building a PivotChart from an associated PivotTable.  Learn how to select the correct chart type and sub-type.  Learn all of the various filtering options including the filer pane.  We will cover the basics of chart formatting, converting a PivotChart to a standard chart, display/hide levels, show/hide details, renaming fields, and more! 

NOTE! A working knowledge of Excel and PivotTable reports is recommended. Need to learn PivotTables, click HERE for more information.

Some of the things you will learn in this class:

• How to Create a PivotChart
• Change the associated PivotTable to adjust the PivotChart
• Pivot (change) the PivotChart
• Edit Format, Design and Layout of the PivotChart
• PivotChart Filter Pane
• Differences and limitations of the PivotChart versus a standard Chart
• Save the PivotChart as a Standard Chart
• Advanced Date, Value and Label Filters
• and more!