PivotCharts from Excel

bradams

New Member
Joined
Oct 23, 2012
Messages
40
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!
 
Last edited:

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,099,379
Messages
5,468,266
Members
406,578
Latest member
Julez_86

This Week's Hot Topics

Top