Statistics How To

How to Create a Histogram in Excel 2007

Microsoft Excel for statistics > How to create a histogram in Excel 2007

Update: This article is for Excel 2007 (which also works for Excel 2010). To create a histogram in Excel 2013, click here.

Watch the video or read the article below:

How to Create a Histogram in Excel 2007: Overview

A histogram (or frequency distribution) is a type of graph that allows you to get a visual picture of your spread of data. While histograms are relatively easy to draw by hand, you’ll get a more professional result in Excel 2007.

How to Create a Histogram in Excel 2007

How to Create a Histogram in Excel 2007: Steps

Step 1: Enter your data into a single column. For example, you might have a list of IQ scores (118, 123, 124, 125, 127, 128, 129, 130, 130, 133, 136, 138, 141, 142, 149, 150, 154). Enter those scores in cells A2 to A18.

Step 2: Enter your lowest value into the second cell of the next column. This is the start of your first bin. In our example, we put the values in column A, so we need to put 118 (the lowest value) into cell B2.

Step 3: Enter the rest of the minimum data values for your bins into the same column from Step 2. If you’re not sure how to calculate these values, see this article on how to create a frequency distribution table.

Step 4: Click on the “Data” tab and then choose “Data Analysis.” If you don’t have the Data Analysis button, you need to add the ToolPak (it only takes a few seconds). See this how to on how to load the Microsoft Excel Data Analysis ToolPak¬†for instructions.

Step 5: Click on “Histogram” and then click on “OK.”

Step 6: Click on the cell icon to the right of “Input Data.”

Step 7: Click on the first value in the column of data (in this example, that’s cell A2). Hold down the shift key, and then click the last cell in that column with a value (in this example, that’s cell A18). Press the “Enter” key.

Step 8: Click on the cell icon to the left of “Bin Range.”

Step 9: Repeat Step 7, only this time, input your first and last bin values (those are the minimum data values).

Step 10:Click on “Chart Output.”

Step 11:Press “OK.”

Tip: To make the histogram bars touch each other, right click and choose “Format Data Series.” Move the “Gap Width” toggle bar to “No gap” and then click “Close.”

That’s it!

Check out our YouTube channel for more stats help and tips!

2 thoughts on “How to Create a Histogram in Excel 2007

  1. Christian

    Thank you for your help. It only took me like 30 minutes to learn how to make a frequency distribution compared to 3 hours using classroom books.

    Thank you