Chart Gallery
Video Tutorials
Trend Analysis
Using R
Data Visualization
 Global Warming
Map Excel Data with Google Earth
Chart Doctor
Advanced Chart Techniques
What's New
 Search Site RSS
   04/4/2008 4:30 PM


        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 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.