problems with macro transfering a range of cells from a sheet to a chart sheet

Hi
I’m having problems with a recorded macro hanging when I try and transfer a range of cells from a workbook sheet to a chart sheet.

I’ve tried copy and paste as picture, copy as a picture and paste as a picture and the camera icon and each time the macro hangs.

Attached a cut down workbook. The ‘power what I’m trying to do’ tab shows the result I’m looking for – (done manually)

Running the power macro on the start page of the workbook would show the fault but for some reason the forum won't let me upload the chart template files so it probably won't run? I've shown the error code below

Please Login or Register  to view this content.

I have no knowledge of VBA - Help for a dummy would be appreciated

Cheers

Tom


Moderator Edit:

Welcome to the forum.

Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.