SOLVED
Home

Excel Crashes while attempting to Create Box-and-Whisker Plot on Specific Data Set

%3CLINGO-SUB%20id%3D%22lingo-sub-790467%22%20slang%3D%22en-US%22%3EExcel%20Crashes%20while%20attempting%20to%20Create%20Box-and-Whisker%20Plot%20on%20Specific%20Data%20Set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790467%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20time%20I%20attempt%20to%20create%20a%20box%20and%20whisker%20plot%20on%20a%20specific%20data%20set%2C%20excel%20crashes.%20I%20even%20copied%20the%20data%20into%20a%20new%20document%20and%20excel%20continues%20to%20crash.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteps%3A%3C%2FP%3E%3CP%3ESelect%20column%20with%20data%3C%2FP%3E%3CP%3EClick%20Insert%20-%26gt%3B%20Box%20and%20Whisker%3C%2FP%3E%3CP%3EExcel%20freezes%20and%20crashes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternate%20Steps%3A%3C%2FP%3E%3CP%3ECreate%20empty%20box%20and%20whisker%20plot%3C%2FP%3E%3CP%3EClick%20Select%20Data%20and%20select%20Column%20A%3C%2FP%3E%3CP%3EExcel%20crashes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20is%20in%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20%3CSPAN%3EExcel%20Version%201905%20(Build%2011629.20246%20Click-to-Run)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-790467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebox%20and%20whisker%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecrash%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eplot%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793101%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Crashes%20while%20attempting%20to%20Create%20Box-and-Whisker%20Plot%20on%20Specific%20Data%20Set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793101%22%20slang%3D%22en-US%22%3EI%20fixed%20this%20issue%20by%20deleting%20all%20of%20the%20blank%20cells%20in%20the%20data%20set.%20Somewhere%20around%2010%25%20of%20cells%20were%20blank%20which%20causes%20this%20freeze%20and%20crash%20for%20some%20reason.%3C%2FLINGO-BODY%3E
dkaufman
New Contributor

Any time I attempt to create a box and whisker plot on a specific data set, excel crashes. I even copied the data into a new document and excel continues to crash.

 

Steps:

Select column with data

Click Insert -> Box and Whisker

Excel freezes and crashes

 

Alternate Steps:

Create empty box and whisker plot

Click Select Data and select Column A

Excel crashes

 

The data is in the attached file.

 

I am using Excel Version 1905 (Build 11629.20246 Click-to-Run)

1 Reply
Solution
I fixed this issue by deleting all of the blank cells in the data set. Somewhere around 10% of cells were blank which causes this freeze and crash for some reason.
Related Conversations