title: Copying graph from Excel to Word with Powershell
body: <p>I am trying to copy a graph from excel to word. The source file in excel has two sheets, 'data' &amp; 'graph' on the 'graph' sheet there are 4 graphs, arranged 2x2.
  The Word document is empty. </p>
  
  <p>I am fairly new to powershell, but i want to automate a weekly report i have to make. This might seem a little steep, but i like a challenge. Plus, the report eats my time.</p>
  
  <p>This is my code:</p>
  
  <pre><code>$xl = new-object -comobject excel.application 
  $xl.Visible = $true
  
  $wb = $xl.workbooks.open("H:\Reporting\ULTRAgraphTest.xlsx")
  $ws = $wb.worksheets.item(1)
  $charts = $ws.ChartObjects()
  $chart = $charts.Item(1)
  $a = $chart.copy
  
  $wd = new-object -comobject Word.application
  $wd.visible = $true
  $path = "H:\Reporting\insertest.docx"
  $doc = $wd.documents.open($path)
  $wd.selection.Paste()
  </code></pre>
  
  <p>When i run this, the files get opened, but it pastes the clipboard content in the word document. It doesn't seem to copy the graph. What am i not seeing here?</p>