We hope this tutorial helps you understand how to create a Box and Whisker Chart in Excel; if you have questions about the tutorial, let us know in the comments. Now read: How to use Slicers in ...

Click the Show data in hidden rows and columns check box. Click OK for ... Select a blank cell next to the values that you want to use to create the chart and type the formula =IF(ISBLANK(C2 ...