The Box and Whisker Chart shows the distribution of data into quartiles, highlighting the mean and outliers. Follow the steps below to create a Box and Whisker Chart in Microsoft Excel: Create a ...

How to Make Box & Whisker Plots in Excel 2007. ... The borders around these two sections will create not only the box, but the median data line within the box as well. Jack Gerard.

Example 18.2: Creating Various Styles of Box-and-Whisker Plots The following example uses the flight delay data of the preceding example to illustrate how you can create box plots with various styles ...

The procedure to create a scatter plot in Excel is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Scatter Plot. Select the appropriate Scatter Plot chart.