Copy pasting Pivot charts to powerpoint using VBA based on the slicer

%3CLINGO-SUB%20id%3D%22lingo-sub-3073493%22%20slang%3D%22en-US%22%3ECopy%20pasting%20Pivot%20charts%20to%20powerpoint%20using%20VBA%20based%20on%20the%20slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073493%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%2C%3C%2FP%3E%3CP%3EHave%20been%20working%20on%20a%20sheet%20which%20has%20a%20lot%20of%20data%20analysis%20ongoing%20in%20it%20from%20which%20there%20is%20one%20bit%20where%20have%20a%20pivot%20table%20and%202%20slicers%20based%20on%20the%20data.%20Now%20each%20slicer%20click%20will%20get%20a%20different%20chart%20and%20a%20VBA%20code%20is%20required%20to%20copy%20and%20paste%20all%20of%20them%20to%20a%20single%20powerpoint%20presentation.%20But%20what%20happens%20is%20when%20the%20slicer%20is%20changed%20the%20chart%20that%20is%20copied%20in%20the%20powerpoint%20also%20changes.%3C%2FP%3E%3CP%3ENeed%20some%20help%20with%20this%20also%20this%20would%20be%20very%20useful%20if%20the%20charts%20are%20not%20pasted%20as%20Images%20so%20then%20in%20later%20stage%20that%20can%20be%20edited%20or%20changed%20accrodingly.%3C%2FP%3E%3CP%3EAttaching%20the%20file%20for%20your%20ready%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAditya%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073493%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Dear All,

Have been working on a sheet which has a lot of data analysis ongoing in it from which there is one bit where have a pivot table and 2 slicers based on the data. Now each slicer click will get a different chart and a VBA code is required to copy and paste all of them to a single powerpoint presentation. But what happens is when the slicer is changed the chart that is copied in the powerpoint also changes.

Need some help with this also this would be very useful if the charts are not pasted as Images so then in later stage that can be edited or changed accrodingly.

Attaching the file for your ready reference.

 

Regards,

Aditya

0 Replies