Knowledge base KB0229

How can I create a box and whisker chart?

Box and whisker charts, also called box plots, can be created using think-cell's Excel data links (see Excel data links). You can download our template Excel and PowerPoint files from the following link:

Box and whisker chart

Simply extract the .zip file contents and follow the instructions in the Excel Workbook to add your data. The template calculates the five-number summary from your raw data and arranges it as a data source for think-cell's Excel link. The linked chart in PowerPoint will then automatically update itself to show a box and whisker chart based on your own data.

  • The whiskers of the box plot are created using error bars (see Error bars) placed between the maximum and 3rd quartile values, and the minimum and 1st quartile values respectively.
  • The boxes are created as stacked segments. If the boxes do not touch the baseline, a segment with no fill is used to "float" the box segments above or below the axis.
  • If a box crosses the baseline, the box is split into two segments, one above the baseline and one below.


think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.