How to Make Box Whisker Plots in Excel 2007

1. Open your Excel data. This instructional will assume that your first data column is in column 'A,' your first data value is in row '1,' and all your columns have 'n' data points.
2. Create new rows for your maximum, upper quartile, median, lower quartile and minimum values.
3. Calculate these statistics by entering the following values under your 'A' column:=MAX(A1:An)=PERCENTILE(A1:An,0.75)=MEDIAN(A1:An)=PERCENTILE(A1:An,0.25)=MIN(A1:An)
4. Copy and paste the same formulas to calculate statistics for your other columns, changing the letter for the corresponding column.
5. Select all the fields with your new statistical calculations. You can press 'CTRL' to select from more than one column.
6. Click the 'Excel Chart Wizard' button.
7. Select the 'Stock Open-High-Low-Close' diagram.
8. Click 'Next.' In the Data Range tab, click on 'Series In: Rows.'
9. Click 'Finish.' A box and whisker chart will display.