Copy Sheet with dynamic chart?
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 to copy sheet in which dynamic charts keep it dynamic formula? In case you didnt know, I use "local define name" in the chart fomula. Thanks all. |
Copy Sheet with dynamic chart?
This happens to local names when used as source data in a chart. It's an
inconvenient feature. Move the sheet to a new book, save this workbook, and close the original workbook without saving. Now open the new book whenever you need the chart, and copy the sheet to wherever you need it. You could turn the new workbook into a template, and insert a new sheet based on this template. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Yurble" wrote in message ps.com... 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 to copy sheet in which dynamic charts keep it dynamic formula? In case you didnt know, I use "local define name" in the chart fomula. Thanks all. |
Copy Sheet with dynamic chart?
It works Jon, Thank you very much. You are so kind
Btw, I have faced with another trouble. It copy all global named name and transfer it in to local name... SO, I have 2 similar name at the same time in which one refer to the template file (you mentioned) |
Copy Sheet with dynamic chart?
Sorry, I'm wrong. It completely works
|
All times are GMT +1. The time now is 03:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com