Error when moving chart into another chart sheet

I'm trying to have a macro move a chart sheet into another chart sheet. I recorded a macro to see how to do it however when I try to run the macro again after I receive the following error:

"The specified dimension is not valid for the current chart type."

The weird thing is that the error appears after the chart has already been moved seemingly successfully. Any ideas of what might be going wrong?

Thanks.

This is the most frustrating error. For some reason this runs if I put a break point on one of the lines in either the original code that I attached or in the version from the reply. But if I don't have a break point it failed with the error that I listed.

Still trying to get this to work and still getting an error on the ActiveChart.Location line. I've attached another file which more closely approximates what I'm trying to do with my full code.

Sorry, to keep upping this thread but I'm against a deadline to get this working (as I'm sure everyone is).

I should have mentioned before that the chart does actually move to the intended location but the code breaks on the same line with the error message that I described.