Excel Box And Whisker Plot Not Working. If you dont see the Chart Design and Format tabs click anywhere in the box and whisker chart to add them to the ribbon. Design Format.
They can be created however by an interesting modification of an EXCEL stock chart specifically the Open-High-Low-Close chart. Rows 20 and 24 dont figure into this step. Excel uses the QUARTILEEXC function to calculate the 1st quartile Q 1 2nd quartile Q 2 or median and 3rd quartile Q 3.
Right-click on the chart select the Format Data Series option then select the Show inner points option.
If a data point is outside 15 times the interquartile range it is designated an outlier and not used to calculate the location of the whiskers. Use the Chart Design and Format tabs to customize the look of your chart. This shows you how to make a Box and Whisker plot in Excel 2016 for Mac. Box and Whiskers chart.
