The box part of the chart is as described above, except that the mean is shown as an ×. You can add a legend as well as chart and axis titles as usual. The chart shown on the right side of Figure 1 will appear.įigure 1 – Excel’s Box and Whiskers chart To access this capability for Example 1 of Creating Box Plots in Excel, highlight the data range A2:C11 (from Figure 1) and select Insert > Charts|Statistical > Box and Whiskers. Starting with Excel 2016 Microsoft added a Box and Whiskers chart capability.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |