To make a Histogram, we need to have two sets of values. We have 50 values of the data in a column, for which we are going to make a Histogram. Histograms are usually used to represent data of any kind, for example, they can be used to represent the Marks obtained by student in a subject.įor this tutorial, the Amount Spent by customers in a shop is used as Input Range of data. We will use numerical data to make a Histogram chart. Histogram is used to represent a distribution of data. In this tutorial, we will learn how to make a Histogram in Microsoft Excel.
