You can the options in the drop-down filter and even select them.
In fact, the pivot table (that’s created with every pivot chart) updates. I demonstrate this disappointing failure in this short demo. Go ahead and test it for yourself with the pivot chart in this Excel file.
Before After Whether you change the State field or numbers in the Amount field, when you want to see those changes immediately represented in your pivot table, follow these simple steps: Step 1 Right-click your worksheet tab, and left-click to select View Code.
Step 2 Paste the following code into the large white area that is your worksheet module.
If you change any of the data in your source worksheet, the Pivot Table will not update automatically.
To manually update it, select the Pivot Table and then go to Analyze Refresh.
However, the code was hanging, and stopping somewhere in the second pivot table update.