Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 155
- Office Version
- 365
- Platform
- Windows
Hi, I have an excel chart working off a pivot.
I want to copy the chart to a powerpoint deck and share the powerpoint with others, who wont have access to the source data.
When I click on the excel chart in excel & hit copy, I go to the powerpoint and when I right click to paste I have the following options:
1. Use Destination Theme & Embed Workbook
2. Keep source formatting & Embed workbook
3. Use Destination Theme & Link Data
4. Keep Source Formatting & Link Data
5. Picture
If I select picture (5) the quality is not as good as if I select (1) Use Destination Theme & Embed Workbook.
The only thing is if I select (1) Use Destination Theme & Embed Workbook & right click on the chart in powerpoint it gives options in the dropdown to Change Chart Type or Edit Data. I ideally dont want the people who I am sharing the powerpoint with to be able to do this and change the chart ideally.
Also, if the source data updates will it change the chart if I select (1) Use Destination Theme & Embed Workbook?
Is there any other option to copy the chart across but have it in good quality?
Thanks
I want to copy the chart to a powerpoint deck and share the powerpoint with others, who wont have access to the source data.
When I click on the excel chart in excel & hit copy, I go to the powerpoint and when I right click to paste I have the following options:
1. Use Destination Theme & Embed Workbook
2. Keep source formatting & Embed workbook
3. Use Destination Theme & Link Data
4. Keep Source Formatting & Link Data
5. Picture
If I select picture (5) the quality is not as good as if I select (1) Use Destination Theme & Embed Workbook.
The only thing is if I select (1) Use Destination Theme & Embed Workbook & right click on the chart in powerpoint it gives options in the dropdown to Change Chart Type or Edit Data. I ideally dont want the people who I am sharing the powerpoint with to be able to do this and change the chart ideally.
Also, if the source data updates will it change the chart if I select (1) Use Destination Theme & Embed Workbook?
Is there any other option to copy the chart across but have it in good quality?
Thanks