Dear charting experts!

I have created dynamic column chart according to Jon Peltier's
instructions on page

http://peltiertech.com/Excel/Charts/...umnChart1.html

Dynamic column chart works fine, I have only problem with copying it. I
copy the whole sheet along with the graph on it. Defined names change
as expected (from Sheet1!ChartValues to Sheet2!ChartValues), however
graph on the new sheet cell references no longer refer to defined names,
but to arrays of numbers. I have to correct these to make graph work
with new set of data. Is there any way to copy sheet and retain cell
references to defined names?

Thanks for the answer,

Marko Pinteric