How to copy sheet with dynamics chart?

[yurble_vn]

Dear all,

I have a sheet with some dynamics charts, and when use "move or copy" to copy the sheet, all the chart formula changed to fix series numbers.

Is there anyway copy sheet in which dynamics charts keep it dynamics formular?

In case you didnt know, I use "local define name" in the fomular.

Thanks all.

[yurble_vn]

Please help,

How copy a sheet which containt a dynamic chart?

I have faced the trouble that, after copy, all the reference in dynamic chart transfer to fix number....., so, it is no more dynamics chart.

Please, any help...

[JonPeltier]

I saw this in another forum someplace. Here's how I answered it.

If you use Move Sheet, the local names will be retained in the series formulas. If you use Copy Sheet, the local names are obliterated. This obliteration seems like a bug, but I've been told it's by design. Tomayto - tomahto. What you have to do is move the sheet with chart to its own new workbook, save the workbook, and move the sheet back. Now you're back where you started. Reopen the new workbook with the sheet and its chart, and move the sheet to where you wanted to copy it in the first place. For each additional copy, reopen the new workbook and move the sheet to its destination.

If you do this a lot, save the new workbook as a template, and insert a new sheet based on this template.

[mdmackillop]

Thanks Jon,
A very useful technique.
Regards
MD

[yurble_vn]

Thanks Jon,

I have shot the trouble by the method you told, it's very kind of you. I have read your answer in other forum but forget to put it here for everyone reference.

BTW, after test, I have found this error. (I mean another trouble I meet, your method is working perfectly )
http://vbaexpress.com/forum/showthre...761#post105761

Please take a look and help

Once again, thanks