Skip to Content

Smart copy charts from excel into powerpoint

According to Analysis for Office help:


In the edition for Microsoft Excel, you can copy a crosstab or chart that is currently displayed in the workbook. In the edition for Microsoft PowerPoint, you can then insert the copied object.

However when I select a chart (based on an SAP datasource) the smart copy button is not activated:

Also it seems to me this was possible and easy to do with the "create slide" button in earlier versions of AO.

Is there any way to achieve this now?

Thanks

Manuel.-

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 16, 2017 at 01:25 PM

    Which version of Analysis Office are you using? There should be a "Smart Copy" which is part of the Tools ribbon. This still works in the latest versions.

    Add comment
    10|10000 characters needed characters exceeded

    • Tammy,

      Version is 2.3.1...

      The Smart Copy button is there and it works perfectly to copy and paste SAP crosstabs. But what I need now is to transfer an excel chart. Pretty much the same way as in this video:

      https://www.youtube.com/watch?v=JRgGY5h3jS0

      (go to 2:50)

      When I select a chart in excel, the Smart Copy button is grayed out, probably meaning a chart cannot be "smart copied".

      The question is then, is there any possibility to transfer an excel chart into powerpoint now that we don't have the "Create Slide" button?

      Thanks in advance.

      Manuel.-

  • Aug 16, 2017 at 06:45 PM

    According to the SAP Help, on page 194, you should be able to do this with Analysis Office 2.4 SP1 - see page 194 https://help.sap.com/doc/f26f2b506c9b1014bf2c9a7eb0e91070/2.4.1.0/en-US/24SP1_analysisplugin_user_en.pdf

    Can you upgrade to 2.4?

    Add comment
    10|10000 characters needed characters exceeded