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.
copying charts
- Thread starter ungoliath
- Start date
Similar threads
- Solved
