How to Make a Histogram in Excel 365īefore Excel 2016, you didn’t have the option to choose a histogram in the charts section of the ribbon.
Secondly, for those of you who don’t have Excel 2013 or older, the second half of this tutorial will show you how to make a histogram using the FREQUENCY function. The first method will show you how to make a histogram using Excel 365 or Excel 2016 onwards. I will now show you two different methods of how to make a histogram in Excel. You may, for instance, want to create a histogram which shows the number of people within the age ranges of 18-27, 28-37, 38-47, 48-57, 58-67 who have filled in the questionnaire. For example, suppose you send out a questionnaire asking for the ages of the people who have filled in the questionnaire. People who work in statistics normally use histograms and it shows how many times a certain variable occurs within a specified range. The y axis is the count or percentage of occurrences in the data for each column and used to visualise data distributions. The x axis buckets a range of outcomes into columns. It looks very similar to a bar chart and it condenses data series into an easy to understand visual by taking many data points and grouping them into logical ranges or bins. A histogram is a chart which groups the data points into user specified ranges. In this tutorial, I will show you how to make a histogram in Excel using two different methods.
