Ch.13--"Pivottables and Pivotcharts"

Chapter 13 is all about another way to organize data. It is called pivottables and pivotcharts. These pivottables let you rearrange and summarize data. To create a pivottable you go to data then pivottable and pivotchart report. Hit next if you want to create a pivottable then select your range of data and finally select where you would like to put the pivottable report. Then it is almost self explanatory after that because the table shows where you would like to drop row fields, column fields and data items. From there you drag your titles to those positions and it creates a pivottable. And if you wish to create a chart of the pivottable, you just click on the chart wizard button on the pivottable toolbar.

The first project wants you to make a pivottable from the data that it gives. So I went to data then pivottable and began making a pivottable. I hit finish and in the row area in the table I dragged Stock Area to it and to the Data area in the table I dragged Cost to it. Now I have a pivottable of Stock Area and Cost.

The second project is another pivottable except this time when I create the table I also put a classification for the page. It asks me to make the row in the table Last Name and the Data in the table to be Grade Point Average. They want the page to be controlled by Class. They only want the senior’s GPA so I go to the top left where class is and click on senior.

This activity wants me to take data, make a pivottable and then make that a pivotchart. A pivotchart will take a pivottable and turn it into a graph that you wish. It utilizes the chart wizard and takes the data from your pivottable. The graph that it wants is a 3-d graph with a title of Total Product Value in Inventory by Stock Area.