ajaya / Voted
The Show Report Filters Pages functionality allows you to copy a pivot table for every value in a Report Filter field. This would be a fantastic bit
read more »
Tell a friend
To add fields to the report filter, you drag them from the top of the PivotTable Field List box to the Report Filter drop zone at the bottom of the P
read more »
Tell a friend
Pivot tables are very powerful. A subset of pivot table operations are available in the pivot chart interface. Sometimes, however, you need to return
read more »
Tell a friend
You can use the tools on the Design ribbon to change from a default chart type to almost any other chart type. (However, you cannot use scatter, XY,
read more »
Tell a friend
Pivot tables work best when they are created from transactional data. Every row in a dataset should represent a detailed transaction. You do not want
read more »
Tell a friend
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
read more »
Tell a friend
You can use a delta chart to plot revenue and a quota as line charts. A special data marker appears halfway between the two lines to show the percent
read more »
Tell a friend
Initially, the INDEX function doesn’t seem that useful. Its syntax, which is used in a later chart example, is as follows:
=INDEX(Rectangular Rang
read more »
Tell a friend