The Excel Box Plot Macro

Creating Box Plots in Excel using the Box Plot Macro

Box plots are a favorite tool of statisticians. Box plots provide a compact way to view and compare the central tendency and variability of related data sets.

But Microsoft Excel does not provide a box plot chart type.

In the interest of supporting the use of Excel as a statistical tool we have created a Box Plot macro you can use with Excel.

Download the Box Plot Macro   If you are using Internet Explorer, right click and select "Save Target As" from the menu.

Installing the Box Plot Macro (and understanding macro security warnings)

Empire State College Excel Box Plot Tutorial

Reading a Box Plot

References

Sample Data

 

 

 

 

 

 

 

 

Resource Information

Excel Macro to create Box Plots

Requires: Excel 2000 or later

 

 

© 2006, Empire State College