Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dificulty in copy and paste when items is filtered in excel 2007 | Excel Worksheet Functions | |||
Excel 2003 and 2007 and Select Multiple Items on Pivot AS Cube bug | Excel Discussion (Misc queries) | |||
Value Filter menu is gray except for Top 10 in Pivot Chart 2007 | Charts and Charting in Excel | |||
Printing Pivot Chart in 2007 | Excel Discussion (Misc queries) | |||
2007 pivot chart formatting | Excel Discussion (Misc queries) |