Smart copy charts from excel into powerpoint

[former_member398618]

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.-

[TammyPowlas]

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...

Can you upgrade to 2.4?

[former_member398618]

I don't think we will upgrade to 2.4 for a while.. But exactly the same is described in the user guide for 2.3 SP3:

https://help.sap.com/doc/f26f2b506c9b1014bf2c9a7eb0e91070/2.3.3.0/en-US/23SP3_analysisplugin_user_en...

Not sure which SP we are on... is 2.3.1.60279 SP3? Probably not. Will try to make sure I am on SP3 to see if that fixes this bug (I'm assuming this is a bug since it is not working as described in the F1 help of the AO add-in).

Regards.

Manuel.-

[TammyPowlas]

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.

[former_member398618]

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.-