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.
ABC analysis is a method used for analysis and management of inventory. Depending on the share in the total value of the stock it distributes items in groups A, B or C. They make up about 70%, about 25% and about 5% of the total, respectively. Since items from Group A account for the largest share of the total value they require frequent and rigorous control. Items from the group B require something smaller, while items from the group C require the least control.
It’s not too difficult to create a chart, but you need to choose the type that best reflects our data. Excel has a multitude of charts, and every one of them suits best certain types of data. In the text that follows you will meet most commonly used charts, with suggestions on how to choose the right one that will meet your needs.