For each sample, the box plot consists of a rectangular box with one line extending upward and another extending downward (usually called whiskers). The box itself is divided into two parts. In particular, the meaning of each element in the box plot is described in Figure 3.
![Plot Plot](/uploads/1/2/5/6/125677885/354387673.jpg)
Make a Chart of Average, Maximum and Minimum Values in Microsoft Excel
By Jim Gordon, co-author of Office 2011 for Mac All-in-One For Dummies in collaboration with SUNY at Buffalo Professor Robert Wetherhold, AMSE fellow | These instructions explain how to make an Average-Max-Min chart like this one: These instructions are for Microsoft Excel 2013. Instructions for Excel 2011 can be found here. |
An Average-Max-Min chart displays the average, maximum, and minimum values where the average is plotted with greater importance. This chart type is used by engineers and scientists. An avg-max-min chart type can be used when an uneven number of data records exist, when gaps exist in the data, or when insufficient samples exist for a more complete analysis.
You're going to need some data to work with. Notice there gaps in the data set.
Using this tutorial you will make an Avg-Max-Min chart. The tutorial also explains how to save your chart as a template.
Follow these steps to make a really great looking Avg-max-min chart.
1. Download the example workbook by clicking the green Excel icon. Your web browser will save AvgMaxMinChart.xlsb in your web browser's default download location. (You can find and set this location in your web browser's preferences.)
2. Open the file AvgMaxMinChart.xlsb in Microsoft Excel.
Notice that our example research data is in the range B2:E10. We will not attempt to directly graph the research data. Instead we will calculate the maximum, average, and minimum for each column of the cellpadding='2' cellspacing='2'>
Jim Gordon's MVP Home