How to Create a Histogram in Excel

Updated

Looking to create a histogram in Excel? Check out this step-by-step guide to see how it’s done.

How to Create a Histogram in Excel

A histogram is a graphical representation of data that shows how often each value occurs. To create a histogram in Excel, you need to have a data set that is already organized by frequency. You can then use the Histogram tool to create your histogram.

What is a Histogram?

A histogram is a visual representation of a data set’s numerical distribution. Histograms put a range of values into a bin or bucket by dividing the entire range into intervals and counting how many values fall into each interval.

What is a Histogram

Histograms were first introduced by Karl Pearson, an English mathematician, statistician, and key person in the grounding of the school of biometrics.

How to Create a Histogram in Excel

To create a Histogram in Excel:

  1. Open your data set in Excel, and highlight the range of values for which you want to create a Histogram.
  2. Go to the Insert section from the top menu and select Histogram.

Excel will automatically format a Histogram based on the range of data you selected. There are likely some additional tweaks you will want to do to get your Histogram how you want it, though. First, you probably want to adjust the intervals on the X-axis.

To adjust the Histogram’s intervals in Excel, click on an interval and press Ctrl+1 to bring up the Format Axis options. Edit the Bin width to set the interval manually. You can also check the Overflow and Underflow bin and set it to a whole number to clean up your change if there are decimals.

How to Create a Histogram in Excel and Change the Bin Size

FAQ

How do I make a histogram chart in Excel?

To make a histogram chart in Excel, first select the data that you want to chart. Then, click the Insert tab and click the Histogram button in the Charts group. Finally, choose the type of histogram that you want to create.

How do you make a histogram in Excel with multiple sets of data?

To make a histogram in Excel with multiple sets of data, you need to use the FREQUENCY function. This function will take your data and return the number of times that each value occurs. You can then use this information to create a histogram.

How do you make a histogram for grouped data in Excel?

To make a histogram in Excel for grouped data, you first need to create a binned data set. To do this, you need to divide your data into a set number of groups. Once you have your binned data set, you can then create your histogram by selecting your data, going to the Insert tab, and then selecting Histogram.

How do you draw a histogram for grouped data?

There are a few steps to take in order to draw a histogram for grouped data. First, you need to determine the class interval, which is the range of values that will be grouped together. Next, you need to find the midpoint of each class interval. Once you have the midpoints, you can then begin to plot them on the graph. Finally, you will need to connect the dots in order to create the histogram.

How do I create a distribution chart in Excel?

To create a distribution chart in Excel, first select the data that you want to use to create the chart. Then, click the “Insert” tab and select the “Insert Statistic Chart” option. Next, choose the type of distribution chart that you want to create. Finally, click the “Insert” button to insert the chart into your Excel spreadsheet.

For more Excel walkthroughs, see our Excel Section.