| ProcessTrends.Com |
| Home |
| Charts - Graphs |
| Climate Trends |
| Global Warming |
| R Resources |
| LearnR Toolkit |
| Excel Resources |
| Google Maps |
| What's New |
| About Contact |
| Search Site RSS |
|
1/8/2011
|
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.
|
