Forum Discussion
dkaufman
Aug 06, 2019Copper Contributor
Excel Crashes while attempting to Create Box-and-Whisker Plot on Specific Data Set
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)
- 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 Reply
- dkaufmanCopper ContributorI 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.