Pivot Chart in Excel 2007 - top 10 items?

[google_poster]

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.

 

[Ed Ferrero]

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

 

[google_poster]

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

Thanks - works great!