please help charting macro hangs on transfer of range of cells from sheet to chart sheet

Hi
I'm new to this forum and to macros

Im using Excel 2007 on windows 7

I'm trying to record a charting macro that creates a chart from a template and transfers the chart to a seperate tab. It works fine until I try and copy a range of cells (all with formulea in them transfering info from seperate sheets) from another sheet in the same workbook as a graphic onto the chart.

I can easily do it manually using the camera function or copy and paste as a photo.

I'd like to include it in the macro but whaterver i try it hangs the macro

All the sheets are in the same workbook.

attached pdf showing what i'm trying to achieve. The chart works fine the table with date and varous meter readings hangs the macro.

Can't work out why?

ragards Tom