Sort news by: Recently Popular | Top Today | Yesterday | Week | Month | Year | rss

ajaya / Upcoming


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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email 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 »
comment Discuss   email Tell a friend