title: Change chart from cell ranges to named range
body: <p>is there a way to do vba by updating the chart data series from cells range to named range, because when i move and copy to a new sheet in the same workbook it changes back to cells range.</p>
  <p>When i move and copy to another sheet it will change to cells range, what i need is a excel vba to replace the cells range to  named range. picture 1 is for sheet 2 and pictures 2 is for sheet 3</p>
  <p>[<img src="https://i.stack.imgur.com/AdFok.png" alt="enter image description here" /><a href="https://i.stack.imgur.com/AdFok.png" rel="nofollow noreferrer">1</a></p>
  <p>[<img src="https://i.stack.imgur.com/f72Gb.png" alt="enter image description here" /><a href="https://i.stack.imgur.com/f72Gb.png" rel="nofollow noreferrer">2</a></p>
  <p>added new pictures below, as you can see, it automatically changes the sheet, which i move and copy to new sheet. i just want to change cell range to named range using vba automatically. [<img src="https://i.stack.imgur.com/y72EK.png" alt="enter image description here" />
  [<img src="https://i.stack.imgur.com/YzcI8.png" alt="enter image description here" /></p>
  <p><a href="https://i.stack.imgur.com/63TBf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/63TBf.png" alt="enter image description here" /></a></p>
  <p>what if i got more named range, how does this vba apply to filling up the same named range in each data range in chart.
  <a href="https://i.stack.imgur.com/apEFA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/apEFA.png" alt="enter image description here" /></a></p>