displaying filtered data in pivotcharts
 

Im using Excel 2007, and trying to produce multiple pivot charts with various
filtered information. I can filter them ok but when i print them out i
cannot tell what has been filtered.
in previous versions the pivot chart would show the grey box with drop down
arrow and by the side it would show what you had filtered, these have gone
and i need some help.

Many thanks

Edward