Download How To Make A Box And Whisker Plot In Excel Pictures. A box and whisker plot — also known as box plot or box and whisker diagram/chart — shows the distribution of numerical values in a data set. Fortunately, it's easy to customize and edit your chart.
Excel 2007 included a number of new features such as the office ribbon interface that were not present in previous versions of the program.
Box plots weren't added into excel until the 2016 update and epplus is based on earlier versions. Since excel doesn't have a box plot chart we are going to have to create one. I know that a box plot chart type is not available in excel 2013 and below. Then find out how to describe their spread and central tendency and compare them in microsoft excel 2016 and excel online will automatically draw vertical parallel box plots from your raw data.