Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Sheet with dynamic chart?
Sorry, I'm wrong. It completely works
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet with dynamic chart? | Charts and Charting in Excel | |||
Dynamic sourcedata when copying chart within sheet | Charts and Charting in Excel | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
dynamic sheet copy | Excel Programming |