title: Copy Charts from one sheet to another
body: <p>I have two Sheets, and would like to copy the Chart from sheet1 to sheet2. </p>
  
  <p>I am using the below code, the code is removing the Chart from Sheet1  and pasting them into sheet2. Instead, I would just like to have the duplicate of the Chart. </p>
  
  <p>ALso, I would like to have my Charts in particular range. How can I edit them ? </p>
  
  <p>Anylead would be helpful </p>
  
  <pre><code> Sub overview1()
      Dim chartobj As Object
      For Each chartobj In Sheets("CAT").ChartObjects
      chartobj.chart.Location xlLocationAsObject, "Overview_1"
  
      Next chartobj
      For Each chartobj In Sheets("Dev").ChartObjects
      chartobj.chart.Location xlLocationAsObject, "Overview_1"
      Next chartobj
  End sub
  </code></pre>