Excel provides two ways of creating PivotCharts. If you’ve already created a PivotTable and want to chart the information on which it focuses, you can save time and space by creating a PivotChart directly from the PivotTable. If you haven’t created a PivotTable and are in- stead more interested in … [Read more...] about Creating PivotCharts in Excel
pivottables
Editing PivotTables in Excel
PivotTables got their name because you can easily rearrange, or “pivot,” them. For example, you can move row headings to become column headings, or vice versa, or you can change the hierarchy of fields within a row or column heading. You can also separate PivotTable data among pages. You can … [Read more...] about Editing PivotTables in Excel
Using Excel’s PivotTable Wizard
Figure 8-1 shows three years of sales data for a microbrewery that sells six types of beer on the West coast. The company recorded sales for each type of beer by state and by season. You can see that with the large amounts of information in the database, it’s difficult to spot trends. Creating a … [Read more...] about Using Excel’s PivotTable Wizard