Then click Insert > Insert Statistic Chart > Box and Whisker, see screenshot:ģ. Select the data that you want to create box and whisker chart based on.Ģ. To create a box and whisker chart quickly and easily, please do with the following steps:ġ. In Excel 2016, 2019 and Office 365, a built-in Box and Whisker chart has been supported for Excel users.
Download Box and Whisker Chart sample file.
In this article, I will talk about how to create a box and whisker chart in each version of Excel. For example, with the help of the box and whisker chart, you can display the statistical data of test scores between different subjects to identify which subject need more attention for the students. In Excel, a box and whisker chart, also named as box plots is used to display the statistical analyses which helps to show you how numbers are distributed in a set of data.