Hi,
See the reply to my question about the same issue (added 16/9).
That works. You just need to modify the macro for every spreadsheet.

I'll have a go at modyfying it so that it is it works for any pivotchart.

Niklas

"Russ" skrev:

In the previous version of Excel that I used you had the option to show Pivot
Chart buttons which detailled how the chart had been filter. I can't find a
replacement for this in 2007 so if someone prints the chart it isn't
comprehensive in that you can't tell how it's been filtered. I create a lot
of these for less experienced users and this info can be critical since
descisions are made based on these charts. Can anyone help please?
--
ATB

Russ