Hi all,
Hope all is good.
Can anyone please help me in getting a solution for the below mentioned problem ?
I have created a Pivot table and based on that I have created a Chart as well.
But when I add or delete some data under "Data" sheet, the "Data source" row value in the Pivot Table will still be the same.
Can anyone please tell me on "How to auto update that 'Data source' row value in the Pivot Table when some data is added or removed instead of changing the data source row value manually everytime.
Thank you all in advance for your time and for the solution that has been provided.
Bookmarks