How to make a histogram chart in Excel?
Histogram chart is usually used to show the distribution of the data as a statistical chart. If you want to know the detail steps about making a histogram chart in Excel, you can read this tutorial.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
In Excel, if you want to make a histogram, you need to do two steps first.
1. Specify the bins of the data. The scale of the bins is limited in the scale of the data. For example, I have a list of grade, and the scale of the grade is from 0 to 100, and now I specify my bins as shown as below screenshot:
Tip: The bins are usually specified as consecutive, non-overlapping intervals of a variable. The bins (intervals) must be adjacent, and usually equal size.
2. Then you need to add the Data Analysis add-in. Click File > Options (or click the Office Button at the upper-left corner > Excel Options in Excel 2007); then in the Excel Options dialog, click Add-Ins tab, then click Go in the right section. See screenshot:
3. In the Add-Ins dialog, check Analysis ToolPak option, and click OK to close the dialog.
Note: In Excel 2007, it will pop up a dialog box telling you have not installed the add-in. Just click the Yes button.
4. Go to Data tab and click Data Analysis function. Then in the popped out dialog, select Histogram and click OK. See screenshots:
5. Then in Histogram dialog, select the data range and the bin range, and specify the output place, and check all the last three options. See the below screen shot:
6. Click OK. Now you can see a histogram chart and a report are inserted and shown as below:
- Create dot plot in Excel
- Create bi-directional bar chart
- Create radar chart/spider chart
- Create doughnut chart in Excel