Where's the report filter value?

May 16, 2010 11:15 AM

Excel2007EmergencyFilter: Is there a way to get my filter value on a Pivot Chart to show up on the actual chart, like it did back in good ol' Excel 2003?

When I create Pivot Charts in 2003, the report filter value is shown on the actual chart, rather than simply being a drop-down menu in the Pivot Chart box that shows up in 2007. Is there any way to remedy this issue? Quite urgently?

posted by undercoverhuwaaah to Computers & Internet (1 answer total)

Best answer: This thread suggests that you can 'add a textbox with a formula referring to the cell containing the pivot table's report filter value.'
posted by jedicus at 12:36 PM on May 16, 2010