skip to Main Content

Box and Whisker Plot Maker

5.0 (1 review)

This Box and Whisker Plot helps you to compare the distribution of the data sets and show it professional visually. Free plot maker in Excel!

Learn more about License Types

Buy Modifiable Version Buy Modifiable Version

The Box and Whisker Plot Maker is using for showing the data sets. You can also see the median, 1st and 3rd quartile, min, and max values inside the data you input. This type of chart is using for analyzing the data set and works for finding is there any unlogical data or calculations inside the inputs. Box and Whisker plot is also using a lot for statistical researches and experiments.


This Box and Whisker Chart Plot Maker template help you to generate this type of chart easily and fast. All you need to do is, filling one of the data input sections according to the data number you have. If you have enormous data, you should input it to the Full Data Input section. Otherwise, it would be better to use the Shorten Data Input section.

Box and Whisker Plot Maker Features:

Chart Section:

In this section, you can see the original box and whisker plot according to the data input you entered. You can select Data source as Full Data or Shorten Data. Once you select your data source, the chart will update automatically. The visualization will be changed with your selection. You can also change the chart title manually from the chart sheet. There is also an opportunity to change the color of the upper and lower box from the leaved cells. After you changed the color of the boxes, please do not forget to click the Refresh button to update the chart.

Box-and-Whisker-Plot-Maker-Excel-Template-Someka-S07Each box and its whiskers are created out of a separate batch of input data. Those data are calculated in a specific way and based on that we get the result visualized as box and two whiskers. We use this box and whisker plot mostly to compare the distribution of values within some time.

Full Data Input Section:

In this section, there is a quiet space for entering your data series.  If the data amount is not enough to create a box and whisker plot, you will see and warning on the top of the Series Name. The template will specify the max, min values, quartiles, and median values of the data set you entered.Box-and-Whisker-Plot-Maker-Excel-Template-Someka-S04

Short Data Input Section:

In this section, you can enter shorten data. You have already know the min value, 1st, and 3rd quartile, median, and max value of the data series. All the important value points of the data set will be shown by demonstrating the box and whisker plot.


Box and Whisker Plot Maker Features Summary:

  • Create Box and Whisker Plot in Excel
  • Full Print Ready
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions

This Box and Whisker Plot Maker is ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


1 review for Box and Whisker Plot Maker

  1. Nancy Barron

    This is terrific. We are using charts and graphs in my financial math class at school. This is very helpful for my students.

Leave a customer review

Your email address will not be published. Required fields are marked *