How to Show PivotCHART "Report Filter" Value?

[dplum]

In Excel 2003 The "Page" Filter is showed as a button on both a PivotTABLE and PivotCHART with the value selected, and this button and its value also print.

In 2007 the "Page" Filter is called the "Report" Filter. In a PivotTABLE the value selected is shown in the PivotTABLE and it also prints. However, in a selected Report Filter value does not show either on screen nor on a print of an associated PivotCHART.

Is there any way to have the Report Filter Value shown for a PivotCHART ideally both on screen and in a printed report?

 

[Andrew Poulsom]

I'm not sure, but can you add a textbox with a formula referring to the cell containing the pivot table's report filter value?

 

[dplum]

Brilliant!
I put a link to the PivotTable's Report Filter Cell (=Sheet1!$B$1) and it works!!

Thanks Andrew!