Skip to Content
0

Smart copy charts from excel into powerpoint

Aug 16, 2017 at 10:22 AM

56

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Aug 16, 2017 at 01:25 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left 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.-

0
Tammy Powlas
Aug 16, 2017 at 06:45 PM
1

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

0