The Essentials of Working with Pivot Tables and Pivot Charts in Excel 2007
Collecting and storing data in Excel spreadsheets is only useful if you can make sense of it. By reviewing the essentials of working with pivot tables and pivot charts in Excel 2007, you can organize and analyze your data so that you can evaluate it based on a number of different variables.
Pivot tables are much more dynamic than standard Excel 2007 tables because they are so easy to manipulate and modify. Excel makes it just as easy to change which fields from the original data source are [more…]
By default, Excel 2007 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in a pivot table. Some pivot tables, however, require the use [more…]
After you create a pivot table in Excel 2007, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]
Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [more…]
Excel 2007 automatically displays new pivot charts on the same worksheet as the pivot table. However, if you move the pivot chart to its own sheet in the workbook, you may find it easier to customize and [more…]