How to create a Box Plot/Box and Whisker Chart in Excel
How to Create a Box Plot/Box and Whisker Chart in Excel
1. Enter the following data and formulas in the first three columns of the spreadsheet starting at row 5 or higher:
2. Enter your data with each set in a separate column starting at row 11. The first column of data should be in column C. If there are more than 500 data points, adjust the range in the Quartile formulas accordingly.
3. Copy the formulas in column C to as many adjacent columns as needed to correspond to the number of data sets. Put the description for each set of data above the formulas.
4. Select cells starting with the one containing “Name” and including all five lines with the formulas and all the columns to be included in the chart. On the Insert menu, click Chart.
5. On the Standard types tab, click Stock under Chart type, and then click the fourth chart sub-type.
The following explanation appears below the chart sub-type:
Volume-Open-High-Low-Close. Requires five series of values in this order.
6. Click Next
7. On the Data Range tab, click Rows under Series in, and then click Next.
8. On the Titles tab, enter a chart title and/or Y axis label if desired.
9. On the Legend tab, click to clear the Show legend check box.
10. On the Axes tab, click to clear the Value (Y) Axis check box under Secondary axis, and then click Next.
11. Select the location for the chart, and then click Finish.
12. Click once on any one of the colored columns to select the series. Do not click one of the white columns.
13. On the Chart menu, click Chart Type. Under Chart type, click Line, and then click OK.
A line that connects the white columns appears in the chart.
14. Click once on the line, and then click Selected Data Series on the Format menu.
15. Click the Patterns tab. Under Line, click None. (optional)
16. Under Marker, click Custom. In the Style list, click the centered line (-) (or your choice). Increase the marker size to 10 or larger.
17. In the Foreground list, click the black color. (or your choice)
18. Adjust the labels and title font and size as desired.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- making predictions using real world data
- using excel to graph data clayton state university
- a complete parametric cycle analysis for ideal turbofan
- how to create a box plot box and whisker chart in excel
- to plot data from pspice in excel bucknell university
- advanced excel statistical functions formulae
- using excel to graph data instructions
- using microsoft excel for graphing
- fullcam using command line and plot digest
- osmosis and the potato lab graphing with excel
Related searches
- how to create a macro in excel
- how to create a checklist in excel
- how to create a sign in sheet
- how to create a spreadsheet in excel
- how to create a barcode in excel
- how to create a formula in excel
- how to create a excel spreadsheet
- how to create a string in matlab
- how to create a dataset in r
- how to create a tuple in python
- how to create a list in java
- how to create a vector in matlab