I have a report (excel workbook) with a number of pivot tables and pivot
charts that is distributed to customers. Some of these customers are not very
familiar with excel and pivot tables.

In excel 2007 pivot charts I would like to show the filtering based on
page-field in the source pivot table. This is readily available in excel
2003. How can the excel 2003 pivot chart filtering be shown in excel 2007?

I know about the pivot chart filtering pane. This is not what I want to
present to customers.

If I print the pivot chart from excel 2007, I would like the filtering to be
shown in the chart. How can this be done?

Regards