Set up Data for a Box Plot
Excel displays the distribution of numbers when you create a plot chart. The first thing to do is set up the data you want to display in your box plot chart. This example will use two columns of data, but you could use more if necessary.
Enter Plot Chart Formulas
Calculating the quartile values is required in order to make a box plot chart. Make another table populated with formulas to calculate the minimum, maximum, and median values, from the table as well as the first and third quartiles.
Calculate Quartile Differences
The differences between each phase must be calculated before creating the chart. Create a third table to calculate the differences between the following.
Minimum valueFirst quartileMedian valueThird quartileMaximum value
First quartile and minimum valueMedian and first quartileThird quartile and medianMaximum value and third quartile
Create a Stacked Column Chart
Using the data in the third table, create a stacked column chart, which can be modified to make a box plot chart. You can format the chart as desired by changing the chart title, hiding the bottom data series, selecting different chart styles or colors, and more. Alternatively, you can make further modifications and convert the chart into a box and whisker plot chart.
