Create a Simple Box Plot Box and Whisker Chart in Excel
Visit this page for details on creating a box plot chart. With a box plot (also know as a box and whisker chart), you can show the distribution of numbers in a set of data. Excel 2013 does not have a builtin Box Plot chart type, but this video shows you how to create one, using a stacked column chart, with error bars. Save time with Excel Chart Tools: Instructor: Debra Dalgleish, Contextures Inc. Get Debra s weekly Excel tips: More Excel Tips and Tutorials: Subscribe to Contextures YouTube: Video Transcript In this workbook, I have sales data for stores in two regions, and I m going to create a box plot, or box and whisker chart, to show how that data is distributed. The first step is to do calculations to get so
|
|