I have done this...I would drop some code in but there is Sooooo much happening in this report you would not be able to figure head from tails.

ALl I had to do to repeat it though was reset ALL my variables. (it wound up creating a whole new workbook)
But I suppose you could make it delete the chart (or sheet) then re-create it with the new data.

Use the macros and edit the code for hints when your stuck