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
Highlighted
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
Round Down to the nearest 5
jshea23 in Excel on
0 Replies
help with formulae
Gavc1 in Excel on
1 Replies
print macro for variable print area
tomb999 in Excel on
0 Replies
Mailing worksheets in excel
Bruno1250 in Excel on
4 Replies
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies