Box and Whisker Plots - Hidden & Empty Cells

Have you tried building your box and whisker plot as a stacked bar/column chart instead of using the built in chart? From what I have been able to gather, the new specialty charts like the built in box and whisker diagram are convenient if you want exactly what the template calls for, but inflexible if you want something a little different (I'm assuming that hidden and empty cells is one of the inflexibilities). Usually, building the chart from one of the basic chart types allows you to regain the flexibility that the specialty chart does not have.

If you are unsure how to build a box and whisker plot as a stacked bar/column chart, here's a tutorial: https://peltiertech.com/excel-box-an...ams-box-plots/