If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart links not updated when copying two worksheets
I thought I posted this but don't see it on the list. I'll try again, may be
the operator, maybe the same problem I am having with Excel. : ) I have two worksheets, one is called Charts and the other called Data. I need to make mulitple copies of these two charts for seperate data sets. I want the charts links to follow to the new data worksheet like the cell formulas do. This is what I do: Cntrl Right click to hightlight both worksheets Right click on the tabs and select Move/Copy check the copy box Create new copies that have the names Chart (2) and Data (2) The Cells in Chart (2) reference Data (2), but the charts still reference the original worksheet Data. I want the chart links to follow to Data (2). Any suggestions? I am working with Excel 2000. Thanks, David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
copying excel chart formats from one chart to another | [email protected] | General Discussion | 0 | August 31st, 2005 02:18 PM |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Group Worksheets and Modify Chart Formats? | Bull Splat | Charts and Charting | 1 | January 16th, 2004 09:43 PM |