timreqop.blogg.se - How to plot a graph in excel 2013

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