 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2007How do I copy a graph to new worksheet and get data from new sheet?
When I copy a worksheet with a graph or just copy a graph and paste in a new worksheet, the source data is still linked to the original worksheet. I've tried editing the sorce data to remove the sheet name to try to make it relative to the current sheet, but that gives me "Error in your formula". Is there a quick way to get the graph to link to the data in the new worksheet? Even a macro would help, if that's what it takes. Thanx in advance... If the chart is embedded in the worksheet, you should be able to copy the worksheet elsewhere, and the copied chart will point to the data on the copied sheet. Replace this sheet's data with the new set of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > When I copy a worksheet with a graph or just copy a graph and paste in > a new worksheet, the source data is still linked to the original [quoted text clipped - 8 lines] > > Thanx in advance... Nope. I highlight the worksheet and copy to a blank worksheet. The graph copies but the source data for the sheet in the new sheet still points to the original sheet. >If the chart is embedded in the worksheet, you should be able to copy the >worksheet elsewhere, and the copied chart will point to the data on the [quoted text clipped - 19 lines] >> >> Thanx in advance... No. Don't copy the cells of the sheet. Copy the sheet. Right click on the sheet tab, and follow Move or Copy to make a copy of the sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Nope. I highlight the worksheet and copy to a blank worksheet. The > graph copies but the source data for the sheet in the new sheet still [quoted text clipped - 23 lines] >>> >>> Thanx in advance... Don't highlight the sheet, copy the contents, and paste onto a blank sheet. Instead, select the sheet and then either right-click on the sheet's tab to select Move or Copy, or use the Edit menu to go to Move or Copy Sheet. Tell it where you want the new sheet & ensure that you've selected to create a copy.  SignatureDavid Biddulph > Nope. I highlight the worksheet and copy to a blank worksheet. The > graph copies but the source data for the sheet in the new sheet still [quoted text clipped - 23 lines] >>> >>> Thanx in advance... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.