Home

Why do box/whisker graphs freeze when pasting from Excel workbook to PPT?

%3CLINGO-SUB%20id%3D%22lingo-sub-847381%22%20slang%3D%22en-US%22%3EWhy%20do%20box%2Fwhisker%20graphs%20freeze%20when%20pasting%20from%20Excel%20workbook%20to%20PPT%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847381%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20work%20in%20IT%20but%20my%20organization%20has%20quite%20a%20lot%20of%20Excel%20power%20users.%20I%20have%20a%20user%20who%20has%20been%20having%20issues%20when%20copy%2Fpasting%20certain%20box%20graphs%20from%20an%20Excel%20workbook%20to%20Powerpoint.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHe%20is%20using%20an%20Excel%20workbook%20that%20has%20a%20bunch%20of%20raw%20numbered%20data.%3C%2FP%3E%3CP%3EHe%20is%20generating%20the%20graphs%20based%20on%20that%20data%20on%20the%20same%20sheet%20as%20the%20data.%3C%2FP%3E%3CP%3EHe%20needs%20to%20present%20this%20data%20-%20so%20after%20he%20generates%20the%20graphs%2C%20he%20copies%20and%20pastes%20them%20(with%20formatting)%20into%20Powerpoint.%20After%2C%20when%20he%20tries%20to%20edit%20the%20graph%20in%20any%20way%20(resize%2C%20change%20values%2C%20etc)%20besides%20just%20moving%20the%20graph%20around%2C%20it%20will%20freeze%20powerpoint%20to%20the%20point%20where%20he%20either%20needs%20to%20kill%20it%20in%20task%20manager%20or%20wait%20about%205%20minutes%20for%20Powerpoint%20to%20unfreeze%2C%20catch%20up%20with%20the%20changes%20and%20allow%20him%20to%20resume%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20does%20not%20happen%20with%20all%20graphs%20-%20it%20does%20not%20happen%20with%20all%20his%20box%20graphs.%3C%2FP%3E%3CP%3EI've%20already%20suggested%20he%20generates%20all%20graphs%20on%20a%20sheet%20separate%20from%20the%20workbook%2C%20OR%20doing%20all%20graph%20manipulation%20in%20Excel%20before%20pasting%20it%20into%20PPT%20-%20but%20he%20isn't%20satisfied%20with%20this%20as%20a%20workaround%20since%20he%20claims%20he's%20been%20working%20this%20way%20between%20excel%2Fppt%20for%20awhile%20and%20this%20freezing%20incident%20only%20started%20happening%20recently.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20as%20to%20why%20this%20happens%20and%20how%20I%20can%20present%20it%20in%20a%20way%20where%20he%20isn't%20going%20to%20feel%20like%20I'm%20forcing%20him%20to%20completely%20change%20his%20workflow%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEXCEL%20GRAPH%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerPoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
chrisftl
Occasional Visitor

Hey all,

 

I work in IT but my organization has quite a lot of Excel power users. I have a user who has been having issues when copy/pasting certain box graphs from an Excel workbook to Powerpoint. 

 

He is using an Excel workbook that has a bunch of raw numbered data.

He is generating the graphs based on that data on the same sheet as the data.

He needs to present this data - so after he generates the graphs, he copies and pastes them (with formatting) into Powerpoint. After, when he tries to edit the graph in any way (resize, change values, etc) besides just moving the graph around, it will freeze powerpoint to the point where he either needs to kill it in task manager or wait about 5 minutes for Powerpoint to unfreeze, catch up with the changes and allow him to resume work.

 

This does not happen with all graphs - it does not happen with all his box graphs.

I've already suggested he generates all graphs on a sheet separate from the workbook, OR doing all graph manipulation in Excel before pasting it into PPT - but he isn't satisfied with this as a workaround since he claims he's been working this way between excel/ppt for awhile and this freezing incident only started happening recently. 

 

Any advice as to why this happens and how I can present it in a way where he isn't going to feel like I'm forcing him to completely change his workflow?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies