{"id":31242,"date":"2023-09-29T14:38:25","date_gmt":"2023-09-29T12:38:25","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=31242"},"modified":"2024-05-24T19:52:34","modified_gmt":"2024-05-24T17:52:34","slug":"create-histogram-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-histogram-in-excel\/","title":{"rendered":"How to Create Histogram in Excel (in 3 Easy Steps)"},"content":{"rendered":"

\"How<\/a><\/p>\n

A Histogram in Excel<\/a> is a graphical representation of the distribution of a dataset<\/strong>.\u00a0In Excel, histograms can be easily created using the in-built tools available in Excel 2016<\/strong>. If you are using an earlier version<\/strong> of Excel, Click here<\/strong><\/a> to know how to create one using other methods.<\/p>\n

In this article, we will explore the following topics –<\/p>\n

Let’s dive in!<\/p>\n

Download the Excel Workbook below to follow along and understand How to Create a Histogram in Excel \u2013 download excel workbook<\/strong><\/span>Histogram-in-Excel.xlsx<\/span><\/a><\/h4>\n

Introduction to Histogram<\/span><\/strong><\/p>\n

Histogram is a graphical representation of data that\u00a0shows frequency distribution<\/strong> i.e. count of data in a specified range. It is a way to visualize the frequency or occurrence<\/strong> of different values or ranges of values within the dataset. It is a commonly used tool to understand trends and patterns of the dataset<\/strong>.<\/p>\n

Histograms will categorize data into different “bins”<\/strong> and count the number of data points that fall within each of these bins<\/strong>. It will then plot the bins on the x-axis<\/strong> and the count of these bins as bars on the y-axis<\/strong>. This is what a histogram looks like –<\/p>\n

\"How<\/a><\/p>\n

 <\/p>\n

Create a Histogram in Excel<\/span><\/strong><\/p>\n

Suppose you have the age of individuals and their corresponding population<\/strong> as shown below.<\/p>\n

\"How<\/a><\/p>\n

Follow the steps below<\/strong> to create a histogram in Excel<\/a> –<\/p>\n

STEP 1:<\/span><\/strong> Select the data<\/strong> you want to use for your histogram.<\/p>\n

\"How<\/a><\/p>\n

STEP 2:<\/span><\/strong> Go to the Insert<\/strong> tab in Excel.<\/p>\n

\"How<\/a><\/p>\n

STEP 3:<\/span><\/strong> In the Charts group, click on the Insert Statistic Chart<\/strong> button and then select Histogram<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

The histogram chart is now ready!<\/p>\n

\"How<\/a><\/p>\n

 <\/p>\n

Customize Histogram in Excel<\/span><\/strong><\/p>\n

You can easily customize the histogram<\/strong> in Excel as per your needs. Here’s how you can make specific customizations –<\/p>\n

Chart Title<\/span><\/strong><\/p>\n

You can customize your chart title by simply clicking on the Chart Elements button<\/strong> (a plus icon usually found on the top right corner of the chart). Check the Chart Title<\/strong> option and edit the text<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

Axis Titles<\/span><\/strong><\/p>\n

You can label the x-axis and y-axis<\/strong> to make your chart more informative. Click on the chart, go to<\/a> the Chart Elements<\/strong> button, and check the Axis Titles<\/strong> option to add labels to your axes.<\/p>\n

\"How<\/a><\/p>\n

Data Labels<\/span><\/strong><\/p>\n

Data labels can be added to the bars of your histogram to display the frequency of data points<\/strong> in each bin. Right-click on the bars<\/strong> and select Add Data Labels<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

Adjusting Axis Option<\/span><\/strong><\/p>\n

You can make any change in the axis by right-clicking on the x-axis and selecting Format Axis.<\/strong><\/p>\n

\"How<\/a><\/p>\n

You can choose the any of following in the format axis section –<\/p>\n