Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart not refering it..
Hi i am trying to move a chart in to a different workbook. now by doing
this the chart i get in the new workbook is the reference to my previous workbook. so any chages in the table is reflected in both the charts. Which i dont want. i just want it to reflect in the current worksheet and not in the new workbook. can someone suggest what shud i do.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart not refering it..
Copy the worksheet that the chart is embedded in, so the chart points to the
copied sheet. Then use paste special to paste the new values or formulas onto the copied sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "ritu" wrote in message oups.com... Hi i am trying to move a chart in to a different workbook. now by doing this the chart i get in the new workbook is the reference to my previous workbook. so any chages in the table is reflected in both the charts. Which i dont want. i just want it to reflect in the current worksheet and not in the new workbook. can someone suggest what shud i do.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying chart not refering it..
Right Click on the Chart, select the Source Data Option and change the Data
Range and Series to point to your open workbook instead of where you copied the chart from. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refering to a named range in a chart: 2007 | Excel Worksheet Functions | |||
copying a worksheet tab with a chart, without losing chart formatt | Charts and Charting in Excel | |||
copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
copying a chart and/or bookmarking a chart | Excel Programming | |||
Copying Chart with Chart Series from Worksheet Name | Excel Programming |