Hi all. I have a pivot table and chart. I just added new data to the source data. I want to update the pivot table and chart with this new data. How do I change the range of source data that the Pivot table/chart are linked to? Thank you so much.
-Zoo
Place the cursor in pivot table and press Alt+J+T+I+D and resize the source range.
Refresh the Pivot Table
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks