PivotCharts (FULL COURSE)

Understanding the process behind the creation of PivotCharts to graphically represent PivotTable data.

The topics:

• Formatting data for a PivotChart
  • Importance of cleansing data for accuracy
  • Benefit of using Format as Table command
• Creating a PivotChart
  • Using the data source
  • From an existing PivotTable
  • Using keyboard shortcuts
• Modifying a PivotChart
  • Contextual ribbons and command buttons
  • The effects of Sorting and Filtering
  • Using and hiding Value Field buttons
• Adding a Secondary Vertical Axis
• Adding a Slicer