Peltier Technical Services, Inc.
- Custom Excel Solutions
Jon's Excel and Charting Pages
- Jon's Charts
- Tutorials
- Excel
- Site Index and Search
- RSS
|
Peltier Technical Services, Inc. Jon's Excel and Charting Pages |
|
Box and Whisker Plots.Box and Whisker charts are commonly used in the display of statistical analyses. Unfortunately, Microsoft Excel does not have a built in Box and Whisker chart type. You can create your own custom Box and Whisker charts, using stacked bar or column charts and error bars, in combination with line or XY scatter chart series to show additional data. Note: there are several different ways that box and whisker plots describe sample data. The charts described in these tutorials have boxes indicating the range of the second and third (inner) quartiles of the data, with error bars indicating the first and fourth (outer) quartiles. The whiskers may alternatively show a more rigorously defined upper control limit, and special markers may be used to indicate outliers beyond these. Any such alternatives are beyond the scope of this exercise. There are other web pages that show how to make Box and Whisker charts in Excel:
Vertical Box and Whisker Charts
This tutorial shows the procedures used to construct a vertical box and whisker plot. In this example, the boxes show medians and upper and lower quartiles of the data, while the whiskers indicate the minimum and maximum values. This tutorial also shows how to add another series representing the means of the data. Horizontal Box and Whisker Charts
This tutorial shows the procedures used to construct a horizontal box and whisker plot. In this example, the boxes show medians and upper and lower quartiles of the data, while the whiskers indicate the minimum and maximum values. This tutorial also shows how to add another series representing the means of the data. Example Box and Whisker ChartsBoxWhisker.zip is a zipped Excel workbook with examples of and step-by-step instructions for constructing vertically and horizontally oriented Box and Whisker plots. Box and Whisker Chart UtilityIn these pages I have described techniques for constructing box and whisker charts in Excel. I have also developed a commercial Box and Whisker Chart utility that allows the user to construct box and whisker charts directly from the data. The utility builds the intermediate summary table and then creates and formats the chart from this table. There is also a free demo version with fewer features. These utilities is designed to work in Excel versions 2000 through 2007. The Box and Whisker Chart dialog is shown below:
Read about the PTS Box and Whisker Chart Utility. |
|
Peltier Technical Services, Inc. Jon's Excel and Charting Pages Peltier Technical Services, Inc., Copyright © 2008. All rights reserved. |
Waterfall Chart
Box and Whisker
