title: Copying charts to powerpoint while keeping source formatting
body: <p>I have a excel sheet containing a pie chart and i would like to copy it to a PowerPoint slide (slide number 10).</p>
  
  <p>I would also want to <strong>keep the source formatting</strong> where by <strong>if i make any format changes</strong> in the pie chart <strong>it should amend in the slide as well</strong>.</p>
  
  <p>Is there any vba coding for this? Came across this code but it does not seem to work for me.</p>
  
  <pre><code>'copy the chart from Excel
          xlSheet.ChartObjects(ChartName).Select
          xlSheet.ChartObjects(ChartName).Copy
      'Select Slide
          Set mySlide = myPresentation.Slides(Charts(r).SlideName)
          mySlide.Select
      'stall to make sure the slide is selected
          For k = 1 To 1000
              DoEvents
          Next k
      'paste on selected slide
          PPApp.CommandBars.ExecuteMso ("PasteSourceFormatting")
          PPApp.CommandBars.ReleaseFocus
      'sit and wait for changes to be made
          For k = 1 To 5000
              DoEvents
          Next k
  </code></pre>