If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 Pivot charts, any way to display filters on the chart?
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. |
#2
|
|||
|
|||
Excel 2007 Pivot charts, any way to display filters on the chart?
Hi,
You can only filter the pivot chart from the Pivot Table Field List or from the PivotChart Filter Pane. This will be changed in 2010 where you will have the option of placing the filters on the chart. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Doug_F" wrote: 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 | |
Display Modes | |
|
|