The written instructions are below the video. To see the steps for creating a simple box plot chart (box and whisker plot), watch

Create a Stacked Column chart type, or a stacked bar chart.In these examples, you'll discover how to: The video shows the set-up steps, and there is a link where you can find written notes about the example. Wait Times: The third example compares airport security line wait times.Watch the video to see the steps, and there are written steps too Average Marker: Further down the page, there's another example, that shows how to add an average marker to a Box Plot chart.Build a Box Plot: In the next section, my video shows how to build a vertical box plot chart, comparing sales in two regions.Store 1 had the most consistent sales over the year, with small boxes, and the shortest span from its minimum, to its maximum.Įxcel 2013 doesn't have a Box Plot chart type, but you can build your own Box and Whisker plot, by following the examples below.Store 3 had 6 months of low sales (light blue box) and 6 months with a wide range of sales amounts (darker blue box).Median number (middle value) for each storeĪt a quick glance, this chart show the following nformation:.Highest and lowest sales numbers for each store.Here is a horizontal box plot chart for the three stores' sales data. This diagram shows the different parts of the box plot chart, and you'll see how to create this, in the video and written steps, further down on this page.

Instead of showing data over time, a box and whisker chart shows the data in numerical order, divided into 4 equal sections (quartiles). compare each store to the other two stores.see how each store's sales progress over the year.sales for three stores in a retail chain,.Most people are familiar with a line chart, where you show data over a period of time.įirst, we'll take a quick look at a line chart, then we'll see how a box plot chart would show the data in a different way.įor both types of chart, the same data will be used:

Download Sample File Box Plot Chart Overview

Excel make a boxplot excel 2010