| 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) | |||
Linear Mode
