Using VBA to copy template worksheet need to change graph data range to new worksheet

[GeneYar]

I am using VBA to create a new worksheet from a template. When the copy function completes the new worksheet is there, but the data range for a graph in the new worksheet still references the template sheet. How can I make the data range for the graph change to the data range on the new worksheet rather than the template sheet.

Thank you in advance for your help,
Gene

 

[Tuelor]

Gene,

You could try adding something similar to the following in to your code to ensure it picks up the correct range:

ActiveChart.SeriesCollection(1).Values = "='" & ActiveSheet.Name &"'!A2:A3"

Editing the above as appropriate.

D