S
srpd
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!
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!