iTechtalk

atom

What’s New in Excel 2007 Pivot Tables:-

If you are a pivot table veteran, you will find a few changes in Excel 2007. Rather than dragging and dropping fields on a pivot table or pivot chart, you now build a pivot table by dragging fields to drop zones right in the PivotTable Field List box. This eliminates the chances of dropping a field in the wrong place and the chaos that would normally ensue.

The drop zones have been renamed in Excel 2007. The old Page fields are now named Report Filter fields. The old Data Fields are now named Σ Values fields. When you are creating a pivot chart, Excel further renames the row fields as Axis fields and renames column fields as Legend fields.

By default, a pivot chart is now created on the same worksheet as the underlying pivot table. This is a welcome improvement: You can now easily see the relationship between the pivot table and the pivot chart. If you want to print only the pivot chart, you can either set the print range to include just the chart, or you can select the Charting Tools Layout ribbon and then choose the Move icon to move the pivot chart to a new worksheet.

Another improvement is that you can now apply more logical filters to fields that are in the row or column areas. Whereas previous versions of Excel allowed you to apply the Top 10 AutoShow settings, you can now ask for fields that match a certain pattern, dates that fall in 8 a certain month, and many other options.