From: srpd on
I'm creating a large workbook with master data on one page and on all
following pages Pivot Tables with associated Pivot Charts, one worksheet per
state, 4 tables and charts per page. When I copy the Alabama formatted page
to another worksheeet and change the Report Filter to Arkansas the table
reflects the correct data, however the chart still shows Alabama data.

Right-clicking on the chart and Select Data Source provides a greyed-out
Chart Data Range. How do I fix this? Ideally I'd like to do this in as few
steps as possible, but will change each chart individually if I must. But,
how?

Thanks for your help!