add sub to created chart

[joedirt123]

I have a macro that creates a new chart sheet and another macro that allows you to click a point on the chart and do something.

The problem is, when i run the first macro, the chart doesnt exist and therefore the point-clicking macro doesnt work. I have to manually paste the macro code into the new chart.

So, is there a way to transfer the code to a new chart, or define the code for all charts in general?