View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero[_2_] Ed Ferrero[_2_] is offline
external usenet poster
 
Posts: 99
Default 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.