Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy Chart shee to other workbook without external refere
Hola,
I need to be able to copy a Chart sheet created in one workbook to another workbook but without external references to the original workbook. I do this within a macro and it always references the original workbook, and I don't want this, I just want the Chart copied (it can be to another Chart sheet or to a new worksheet) to the new workbook. Is this possible? Thank you in advance for your help. Regards, OMER |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy Chart shee to other workbook without external refere
You can not copy just the chart, you also need to copy the data source, in
order to avoid leaving the source workbook reference. Also, remember that chart as objects have names so you must account for this as a variable. -- If this posting was helpful, please click on the Yes button on the bottom right of this window. Regards, Michael Arch. "OMER" wrote: Hola, I need to be able to copy a Chart sheet created in one workbook to another workbook but without external references to the original workbook. I do this within a macro and it always references the original workbook, and I don't want this, I just want the Chart copied (it can be to another Chart sheet or to a new worksheet) to the new workbook. Is this possible? Thank you in advance for your help. Regards, OMER |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy Chart shee to other workbook without external re
Thank You Michael for your response.
If this was a embedded chart that wouyld be easy, copy the range and then then chart. Since this is a Chart sheet, if I copy the Chart it holds the reference to the original workbook source, so copying the source data doesn't really helps. Maybe if I copy the source data to the new workbook and then generate the Chart it would work. I was trying to avoid doing this. Any other thoughts? "Michael Arch" wrote: You can not copy just the chart, you also need to copy the data source, in order to avoid leaving the source workbook reference. Also, remember that chart as objects have names so you must account for this as a variable. -- If this posting was helpful, please click on the Yes button on the bottom right of this window. Regards, Michael Arch. "OMER" wrote: Hola, I need to be able to copy a Chart sheet created in one workbook to another workbook but without external references to the original workbook. I do this within a macro and it always references the original workbook, and I don't want this, I just want the Chart copied (it can be to another Chart sheet or to a new worksheet) to the new workbook. Is this possible? Thank you in advance for your help. Regards, OMER |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom error bars bug -- copy pasting chart does not update refere | Charts and Charting in Excel | |||
Copy a specific range of cell values into an external workbook | Excel Programming | |||
if an element in a row is true then copy whole row to another shee | Excel Programming | |||
3 cells are named together - how refere to them in one chart reference field (a seriescollection(1) ) | Excel Programming | |||
3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel |