Advanced Spreadsheets – Pivot chart

Summarizing Data with Pivot Tables

Using the Internet, conduct a thorough search for more information on one of the subtopics listed below as explained in Excel eText Module 8. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:

Choose from the following:

Session 7.3

  • Create a Pivot Chart
  • Apply a slicer to multiple PivotTables
  • Create a timeline slicer

You may also be specific and answer one of the following questions with a 150-word count to meet the Week 8 Discussion Board in reply to my post::

  1. What are the four areas of a PivotChart?
  2. Can you create a PivotChart without a PivotTable?
  3. Can any Excel chart type be turned into a PivotChart?
  4. How do you apply the same slicer to multiple PivotTables?
  5. Can a timeline slicer be used with Excel tabs as well as  PivotTables?
  6. When do you need to refresh a PivotTable?