Whenever I copy a chart from one sheet to another I'd like it to copy the links so that it reads the same ranges off the sheet it's copied on. If the original chart reads A1:B50 on sheet 1 and I copy it to sheet 2 it still reads the values from sheet 1 instead of sheet 2. Is there a setting or way to have the data read from the sheet it's copied to. I've got 10 series on 80 sheets and would desperately apprecieate any way of not having to do this 800 times.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
copying charts
- Thread starter ungoliath
- Start date
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Similar threads
- Question
- Replies
- 15
- Views
- 334
- Replies
- 0
- Views
- 200
- Replies
- 0
- Views
- 133
- Replies
- 15
- Views
- 436
