Histogram

Histogram is a diagram that is used for the graphical presentation of the statistical distribution of  values. It consists of columns, arranged in descending order, which represent the frequency of their repetition. Excel 2016 provides the ability to create two types of charts: Histogram and Pareto. Pareto differs in that it is a combination of two charts: columns and lines. Columns show values, and the line illustrates their cumulative growth.

Histogram is a chart that we can use to track the value of inventory of individual items and their impact on the total value of inventories. In the example that follows, we have a table with two columns. In the first, the items are listed, and in the second value of items in the inventory. We start by selecting the values in the first table. Then, select the Recommended Charts from the Insert ribbon, further in the dialog box that opens click on All Charts. In the list of chart types, we will find the Histogram option, and in the central part of a window we’ll se its preview. Above preview are two smaller images (thumbnails) that indicate the types of charts: Histogram and Pareto. Select Pareto and click OK.

A Pareto chart will appear in the worksheet. In columns we can see the value of inventories of certain items, and the line shows us how it affects the total value of inventories. Clicking on the line will show markers that indicate the contribution of individual values. If we click on the third column (Baget bread 500g), notice the marker, and then look at its value on the secondary axis, we will see, for example, that the sum of the values of the first three articles makes up more than 50% of the value of all the items in the inventory.