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
Highlighted
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
Highlighted
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
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies
Resizing table Error
birkettsl in Excel on
1 Replies
Conditional formatting assistance please
c_frndz in Excel on
4 Replies
delete one marging
fred83 in Excel on
4 Replies