Pivot Chart in Excel 2007 - top 10 items?
 

Any ideas where the "top 10" feature is hidden in Excel 2007 Pivot
Charts? I looked everywhere, consulted the help, but "Value Filters"
is just not in any menu, nor is "Filter" for values.
Many thanks.

Pivot Chart in Excel 2007 - top 10 items?
 

In the PivotChart Filter Pane, click the down-arrow next to one of the
Category fileds or Series fields, then select 'Value Filters' from the
drop-down menu. The Top 10 option is down the bottom.

Ed Ferrero
www.edferrero.com

Any ideas where the "top 10" feature is hidden in Excel 2007 Pivot
Charts? I looked everywhere, consulted the help, but "Value Filters"
is just not in any menu, nor is "Filter" for values.
Many thanks.

Pivot Chart in Excel 2007 - top 10 items?
 

On Mar 26, 5:12 pm, "Ed Ferrero" wrote:
In the PivotChart Filter Pane, click the down-arrow next to one of the
Category fileds or Series fields, then select 'Value Filters' from the
drop-down menu. The Top 10 option is down the bottom.

Ed Ferrerowww.edferrero.com

Any ideas where the "top 10" feature is hidden in Excel 2007 Pivot
Charts? I looked everywhere, consulted the help, but "Value Filters"
is just not in any menu, nor is "Filter" for values.
Many thanks.

Thanks - works great!