Box And Whisker Plot Excel 2007 Add In. On the Insert tab in the Charts group click the Statistic Chart symbol. Whisker Plot in Excel is an exploratory chart used to show statistical highlights and distribution of the data set.
The following illustrates such charts created by the Box and Whisker Plot Creator. Interpretation of Box and Whiskers chart in excel. A basic box and whisker plot chart appears on the worksheet.
Jun 07 2011 To add the up whisker select the 3Q Box seriesthen in the Chart Tools.
Choose the Plus direction select Custom for Error Amount and click on Specify Value. Nov 11 2019 Example 2 Box and Whisker Plot in Excel. For data that is all negative or is mixed there is a slightly different way. Select INSERT Recommended Charts and then select the sixth option to add a stacked column chart to the worksheet.
