Box Whisker plot - when adding gaps, whiskers disappear

Hello!

BoxWhisker.xlsx

In the above attached sheet, you can see a box whisker plot. I want to add a gap between the second and the third box and between the fourth and fifth box. To achieve this, I've added two blank columns between the data columns. The problem is, that every time I add a blank column, whiskers disappear from a box. Adding two blank columns generates the disappearance of the whiskers at box 5 and 6. Do you know a fix for this?

Please see attached. BoxWhisker1.xlsx

I added blank columns between the data columns - like you tried.

To make whiskers line-up, I had re-select its range.

If you frequently do box-and-whisker, try http://www.vtools.net

No reason. Just leftover from troubleshooting steps....