Update Chart data in dynamic range

Hi all,

I am using Excel 2016 and want to update a "Box and Whisker" chart with new "Source Data" in a dynamic range.
One workaround is to delete "Chart 1" and create a new "Box and Whisker" chart but how to update existing chart?
I have tried below codes but I can't get it to work.

Please Login or Register  to view this content.

Any help is much appreciated.

Please, can anyone help me with this problem?