Excel Box Plots - Group and Trend
| 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.
|
