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

Histogram chart excel 2013