|Box Plots in Excel
Excel does not provide a pre-made Box Plot option. With a few steps, however, Users can make there own Box
Plots like those above.
and Neville Hunt
have tutorials on making Box Plots.
box_plot_trend.zip download lets you how
make a group or trend box plots in Excel. This workbook includes 2 working example box plots
that can be used as templates for making group or trend box plots. Example 1 - shows Box Plots for 4 groups of data. Example 2 - shows Box Plot trend over 16 weeks. You can replace the example data to create your own charts.