Filtering a Pivot Chart without filtering the Pivot table

[lovallee]

Hello,

I use Excel 2007.

I have pivotChart that feeds from a PivotTable.

When I am in the PivotChart and I filter data using a PivotChart field (legend field), the corresponding PivotTable column field automatically replicate the PivotChart filter setting. And this is not what I want. I want the Pivot Table to remain unfiltered. Is that possible?

Alternatively, can I have a single pivot table feeding several pivot chart, each pivot chart having different filter settings (legend field)?

Thanks.

Louis