19. PivotTables & PivotCharts

A PivotTable does for Data what a Rubik's Cube does for fun - it lets you keep rearranging views until you have your data just the way you want it!

We used the data from our combined worksheet to creat a PivotTable. We added and then kept changing the view of the data so we could see it in different ways. In addition, we filtered the PivotTable so we could limit what we saw to a smaller portion of the data. We used a PivotTable Design to enhance the look of our work.

Then we created and formatted a PivotChart. We changed the order of the data in the Chart, and noticed that the data changed in the Table as well. Conversely, we changed the order of the data in the Table and noticed that it changed in the Chart. There is a wonderful interactivity between these two elements.

Materials Covered:Excel Project 9 - Importing Data, Working with PivotCharts, PivotTables, and Trendlines, pp. EX 745-760

Assignment 10 - Case 6: Working with Multiple Worksheets and Workbooks:

• Tracking Notebook Sales
• Follow the instructions to download your file, complete work on it, and then to upload it for grading.
• In your journal, write a short note letting me know what you learned from working with Charts in this case. Thanks.