Excel for Statistics > How to Create a Histogram in Excel
Watch the video or read the steps below:
This article covers Excel 2013. If you want to make a histogram in Excel 2007 or 2010, click here.
Histogram in Excel 2013: Steps
Step 1: Load the Data Analysis Toolpak, if it isn’t already installed. To check if the Toolpak is installed, click the “Data” tab and look to the far right; if you see Data Analysis, then the Toolpak is installed.
Step 2: Enter your data into a single column. For example, type your values into column A.
Step 3: Enter your BINs into a single column (for example, column B) (What is a BIN in statistics?). In Excel, you’ll want to enter the upper boundary for the BINS in that column. For example, if you have 0-10, 11-20 and 21-30 you would enter 10,20,30.
Step 4: Click the “Data” tab, then click the “Data Analysis” button.
Step 5: Highlight “Histogram” and then click “OK.”
Step 6: Type the location of your data into the Input Range Box. For example, if your data is in cells A2 to A10 then type A2:A10 into the box.
Step 7: Type the location of your BINS into the “Bin Range” box. For example, type “B2:B4” into the box to indicate your BINS are in cells B2 to B4.
Step 8: Click an option for where you want your data to appear. For example, click the “New Worksheet” button.
Step 9: Check the “Chart Output” box. If you don’t check this, you’ll only get a frequency chart (a list), not the actual histogram.
Step 10: Click “OK” and Excel will create the histogram.
Tip: Histograms traditionally do not have gaps between the bars. To correct this, right click just outside the chart area (but within the chart window). Select “Format Chart Area” and click the down arrow next to “Chart Options.” Select “Series Frequency.” Click the Three Bars to the right (Series Options.” Use the slider to make the gap width zero.
Check out our YouTube channel for more Excel/stats help and tips!
If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!