Excel 2007 : Graph named series not copying with sheet

Afternoon all,

I have a worksheet that is intended to be duplicated in its workbook as many times as is required.

The worksheet contains a graph, for which the data is in dynamic named ranges specific to the worksheet.

When I make a copy of the worksheet, the sheet is successfully duplicated, as are the named ranges. However, the graph no longer refers to the named ranges, rather the static range that was defined by the dynamic range prior to copying.

Am I doing something wrong, or is there a workaround for this?

Thanks,

Dave