SOLVED

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

Copper 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
best response confirmed by dkaufman (Copper Contributor)
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.
1 best response

Accepted Solutions
best response confirmed by dkaufman (Copper Contributor)
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.

View solution in original post