6 Replies Latest reply: Mar 7, 2014 3:14 AM by Mandy Lamb RSS

    macro export of bar chart as a bar chart

      I have been trying now for hours and just can't get it right!

      I am trying to export a bar chart as a bar chart in a macro to excel, however it just pastes it as a table. Is there any way that I can paste as a picture or bar chart into excel.

       

      The macro script i am using is :

      Set chartToExport = ActiveDocument.GetSheetObject("CH2231")
           Set chartProperties = chartToExport.GetProperties
           chartToExport.CopyTableToClipboard true
      curSheet.Paste curSheet.Range("A50")