Create a box plot
OverviewStep 1: Calculate the quartile valuesStep 2: Calculate quartile differencesStep 3: Create a stacked column chartStep 4: Convert the stacked column chart to the box plot styleSee AlsoIf you''re doing statistical analysis, you may want to create a standard box plot to show distribution of a While Excel 2013 doesn''t have a chart template for box plot, you can create box plots by doing the following steps:1.Calculate quartile values from the source data set.2.Calculate quartile differences.See more on support.microsoft dashboardsexcel
Excel Tutorial: How To Create Distribution Chart In Excel
Insert a Box and Whisker chart (Insert > Insert Statistical Chart > Box and Whisker) to show median, quartiles, and outliers succinctly. Use box plots for comparing