(Excel 95 or later))
(Excel 95 or later))
(Excel 95 or later))
(Excel 95 or later)
(Excel 95 or later)
(Excel 95 or later)
(For Excel 95 or later)
Copy the file BoxPlotMacro.xls to your disk. It will open a blank worksheet where you can enter data and run the macro. If your data is in another worksheet, you must also have BoxPlotMacro.xls open to run the macro.
(Excel 95 or later)
Note: It is not essential to specify your own bin ranges, but it is highly advisable. If you leave the "Bin Range:" input box blank, Excel will choose the bin ranges itself. Enough said. When setting up your bin ranges, make all the bin widths the same. Make sure there are no sample values to the left of the first bin endpoint or to the right of the last. (You can sort the values in your column into ascending order via Data: Sort). Thus there should be no sample values in the first bin or in the last bin (which Excel creates beyond your last endpoint and labels "MORE"). These bins can be deleted from the histogram after the event, by deleting the appropriate cells from the table of frequencies that Excel creates. The graph can be resized by clicking it and dragging a corner. You can delete various annotations from the graph by clicking the offending object and deleting. To remove the gap between the rectangles double click one of the rectangles, select "Options" in the dialogue box which appears and set the "Gap width" to 0. Excel labels the midpoint of each rectangle with the endpoint of the interval. There appears to be nothing you can do about this. You can change the diagonal orientation of the labelling by double clicking the axis, but it still remains very confusing. The best idea would be to completely remove the labelling and redo it in some graphics editing package. The problems arise because Excel thinks it is drawing a bar chart.