This option is not relevant in this example as the categories are all different because the employees all have different names.Īutomatic: Excel will automatically decide what bins to create. Here are what the different categories mean:īy Category: Use this option when there are repetitions in categories and you want to know the sum or count of the categories. Use the Format Axis box to customise your histogram

The Format Axis options pane will open on the right where you can select different options to customise your histogram.

You can customise your histogram chart by selecting Format Axis in the shortcut menu Right click the vertical axis and select Format Axis The histogram will be embedded into your worksheet This will insert the histogram in the worksheet.Select the histogram chart in the Excel ribbon Under the Charts group select Insert Static Chart and then select the Histogram chart icon Click on the Insert tab in the ribbon.In this example, I have highlighted the range A1:B16

Here are the steps to create a histogram in Excel. To make a histogram in Excel, I will use the above dataset which shows a list of employees working in a company along with their ages. A dataset with a list of employees in a company with their ages Luckily, Excel 365 and Excel 2016 introduced the histogram chart as one of its default chart options and therefore you can create one very quickly. As a result, this made making a histogram a little more difficult. 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.

Histogram in excel 2013