PivotTable and PivotChart with Microsoft Excel
How to set up a pivottable in Excel 2007 is covered in the article linked below. For those of you using Excel 2007 this post covers the basics required to set up a pivot table.
PivotTable and PivotChart with Microsoft Excel
In this post I use a sample spreadsheet that stores the grades of a college student to show how to create a pivot table and a pivot chart using Microsoft Excel 2007.
Note: Although I use Microsoft Excel 2007 to illustrate the creation process, I provide at the end of this post a spreadsheet compatible with Microsoft Excel 2003.
Pivot Table
A pivot table is extremely helpful when we want to summarize data through different forms. It gives us the possibility of arranging what data we want summarized and in what shape we want them.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
