title: VBA Copy & paste chart in excel
body: <p>Im trying to copy a graph from on sheet when a condition is met. For example</p>
  
  <blockquote>
    <p>IF range ("G5") = "Team 1" Then</p>
    
    <p>Copy and Paste Graph at range (H15:N31)</p>
    
    <p>Then remove the graph when the work sheet is exited  or another team
    is selected.</p>
  </blockquote>
  
  <p>Any ideas on the VBA code i would need to make this happen. </p>
  
  <p>I have attempted to use INDEX &amp; MATCH fomrulas to populate a graph on the same sheet then hide the columns however this has not worked usually end up with N/a. </p>
  
  <p>I have also seen various segments of code on the internet however dont fully understand how they have done what im asking. </p>