???Replicate a sheet but chart still link to original sheet
I have a chart with named range in Sheet1.
When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is still linking to Sheet1. How can I make the source data link to sheet2 automatically. As I have to replicate sheet1 into 10 different sheets, the automation will help a lot. Would appreciate advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
???Replicate a sheet but chart still link to original sheet
Jon Peltier has instructions and a sample workbook with code that
changes the series formulas: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html Jaylin wrote: I have a chart with named range in Sheet1. When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is still linking to Sheet1. How can I make the source data link to sheet2 automatically. As I have to replicate sheet1 into 10 different sheets, the automation will help a lot. Would appreciate advice -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com