title: Maintaining a dynamic named range in a chart when copying a worksheet
body: <p>I am trying to automate charts for a spreadsheet with a lot of worksheets.</p>
  
  <p>I'm building all the charts/graphs I need on a template worksheet and making them dynamic using named ranges <code>(OFFSET + COUNT)</code>. Once I have this template completed I would like to be able to copy the worksheet <em>(while keeping it in the same workbook)</em> and have the charts update when I drop in new data on each new worksheet.</p>
  
  <p>Each worksheet will use the <strong>same names</strong> for the ranges (generic financial words such as <code>margin</code> and <code>volume</code>), so I've restricted them to the worksheet on which they're being used (rather than a global scope).</p>
  
  <p><a href="https://i.stack.imgur.com/Czih2.png" rel="nofollow noreferrer" title="dynamic named range in chart">
  <img src="https://i.stack.imgur.com/Czih2.png"></a></p>
  
  <p>When I copy the worksheets, the named ranges referenced in the charts are replaced with the static cell addresses rather than copying with the chart. The dynamic named ranges copy with the worksheet and are only able to be referenced on the new worksheet (which is what I want). </p>
  
  <p><a href="https://i.stack.imgur.com/rbgzh.png" rel="nofollow noreferrer" title="dynamic named range dropped from chart">
  <img src="https://i.stack.imgur.com/rbgzh.png"></a></p>
  
  <p><strong>Is there a way to make it so charts maintain the dynamic named ranges?</strong></p>