Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
New to 2007, searched, no joy.
In prior versions, when building a pivot chart, one could see the filters and their values on the actual chart; page filter, categories, and X axis. in 2007, I don't see this as an option; filters are in their own dialog box and are not displayed on the actual chart. This is problematic especially for page fields because I used the displayed filters as proxies for chart titles; you could easily see if the displayed chart was filtered for a data subset or for all data. Now, I need to remember to add the filter information to the chart title which is easy to foget and a PITA to do. I tried turning on the 'display classic' in the pivot table settings but this doesn't carry over to the chart. Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Issues when pivot charts are refreshed and pivots has filters | Charts and Charting in Excel | |||
Print filters with Pivot Chart in Excel 2007 | Excel Discussion (Misc queries) | |||
Bug? Chart filters are changing other charts | Charts and Charting in Excel | |||
Excel 2007 OLAP Pivot table Row Filters | Excel Discussion (Misc queries) | |||
Using Pivot Charts, how to hide field values in second level filters? | Excel Discussion (Misc queries) |