Obviously the title should have said PivotChart to PowerPoint (sorry!)
I'm looking for a way to paste a PivotChart into Powerpoint without retaining the link to the Excel file. Everything I have found so far is about how to keep the link active. I'm looking to break the link so I can use the slicers in the same pivot chart to generate multiple graphs that can then be copied over to the Powerpoint. One other requirement is that I can't have the floating slicers visible in the Powerpoint. That is the reason the paste as picture options I've seen won't work. I know (or at least am 90% sure) I can break the link after I insert it. However, the only way I know to do it is a somewhat of a time- consuming process. So to summarize what I'm looking for:
1) A way to insert a PivotChart into Excel that breaks the link and that does not display the floating slicers in the Powerpoint
OR (if #1 is not possible)
2) A shortcut to break links after the PivotChart has been inserted into the Powerpoint
Thank you in advance!
I'm looking for a way to paste a PivotChart into Powerpoint without retaining the link to the Excel file. Everything I have found so far is about how to keep the link active. I'm looking to break the link so I can use the slicers in the same pivot chart to generate multiple graphs that can then be copied over to the Powerpoint. One other requirement is that I can't have the floating slicers visible in the Powerpoint. That is the reason the paste as picture options I've seen won't work. I know (or at least am 90% sure) I can break the link after I insert it. However, the only way I know to do it is a somewhat of a time- consuming process. So to summarize what I'm looking for:
1) A way to insert a PivotChart into Excel that breaks the link and that does not display the floating slicers in the Powerpoint
OR (if #1 is not possible)
2) A shortcut to break links after the PivotChart has been inserted into the Powerpoint
Thank you in advance!
Last edited:
