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.
Jon Peltier and Neville Hunt have tutorials on making Box Plots.
The 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.
box_plot_trend.zip
|