If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Refresh Pivot Chart with Table?
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! |
Thread Tools | |
Display Modes | |
|
|