Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want to copy Excel Chart to another sheet without the Data

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-02-2012
Member
 
Join Date: Feb 2012
Posts: 11
Want to copy Excel Chart to another sheet without the Data

I have got a worksheet with ten charts on it. I need to copy the worksheet with all its data and related charts to new sheets or files so I have a page for every day, with different data entered as well. But when I copy the worksheet with embedded charts and paste it into a new file, the charts pull their source data from the original worksheet, not the new one. The source data Value box is written as such, ='03-09-10'!$D$12.

Reply With Quote
  #2  
Old 25-02-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: Want to copy Excel Chart to another sheet without the Data

Here is a way that makes a new duplicate sheet. Open the two workbooks and in XL 2003 use Windows > Arrange or in Xl 2007 use View > Arrange to have them side by side. If you are talking about one workbook then just click on the tab of the worksheet holding the data and charts and hold down the CTRL key and drag the tab from one book to the other (you will see an icon looking like a piece of paper with a + sign) --- with one file drag from one place to another in the tab line-up.
Reply With Quote
  #3  
Old 25-02-2012
Member
 
Join Date: Jun 2011
Posts: 632
Re: Want to copy Excel Chart to another sheet without the Data

Is the chart embedded in the sheet? Or is it a standalone chart sheet. If its a chart sheet, then select the data worksheet, hold Ctrl and select the chart sheet, then hold Ctrl and drag both to the other workbook.
Reply With Quote
  #4  
Old 25-02-2012
Member
 
Join Date: Jun 2011
Posts: 486
Re: Want to copy Excel Chart to another sheet without the Data

You have to enable an option for this to work if the charts are embedded on the worksheets where the data is, rather than on a chart sheet of their own. Go to Excel options > Advanced > Cut, Copy and Paste section. Enable "Cut, copy, and sort inserted objects with their parent cells". Now use Ctrl-drag technique, or a normal right click > "Move or copy" to copy the sheet and the chart should update the formulas to the worksheet it is embedded on (not back to the original). If your charts are on worksheets other than the ones where their source data is, then you need to do something similar to what is suggested for chart sheets, ie to select the sheet with the chart on it and the sheet with the data on it and copy them all at once. The new copied sheet with the chart will then point at the new copied sheet with the data, rather than the old one.
Reply With Quote
  #5  
Old 25-02-2012
Member
 
Join Date: Jun 2011
Posts: 798
Re: Want to copy Excel Chart to another sheet without the Data

I just found a solution to this and I've been wrestling with this problem for months now, so I wanted to share it:
  • Create a New Workbook
  • Copy the worksheet to the new workbook (right click: Move or Copy, select create a copy and put it in the new workbook)
  • Change the name of the worksheet to its new name in the new workbook
  • Move the newly named worksheet back to the old workbook.
The chart references will point to the data on the newly named worksheet.
Reply With Quote
  #6  
Old 25-02-2012
Member
 
Join Date: May 2011
Posts: 521
Re: Want to copy Excel Chart to another sheet without the Data

I was reading this today as I was having the same problem. However, I have found that if I use the "Links" option under the edit menu, and change the source of the offending link to the new workbook containing the copied data and charts, all the links are changed properly.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Want to copy Excel Chart to another sheet without the Data"
Thread Thread Starter Forum Replies Last Post
There is no data in Excel Pie Chart Tarani MS Office Support 2 25-02-2012 12:27 PM
How to do Copy/Paste on protected work sheet in Microsoft Excel Chini mao MS Office Support 1 14-01-2012 06:58 PM
How can I insert the text box into the chart in the Excel sheet of Office 2011? Aag-Man Windows Software 8 12-09-2011 10:46 PM
how to copy data from sheet 1 to sheet 2 using macro Messenger Windows Software 3 26-10-2010 06:28 AM
How to copy data into next empty cell in new sheet Saaarc Software Development 3 20-10-2009 12:21 PM


All times are GMT +5.5. The time now is 01:10 PM.