???Replicate a sheet but chart still link to original sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Change Source Data in Chart 3
Odd Chart Format Results 1
Data from 3 different sheets in the same workbook 1
XL2007: line chart lines disappear when referenced workbook is not open 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Charts return zero? 5
Add values to a series in a chart 1

Back
Top