How to Create a Histogram in Excel For Windows and Mac
In frequency data analysis, histograms are a helpful tool that allows users to organize data into categories (referred to as bin numbers) in a graphic that resembles a bar chart. These are the steps for making a histogram Microsoft Excel.
Excel Histogram Creation Guide
Simply put, frequency data analysis is collecting data and attempting to ascertain the frequency of that data. For instance, you could want to look at a group of student test results and see how often those outcomes appear or how frequently results fall within specific grade ranges.
This data may be easily seen in an Excel chart thanks to histograms.
- Open Microsoft Excel and choose your data to do this. The data may be chosen manually or by choosing a cell within your range and hitting the Ctrl+A keyboard shortcut.
- Select "Insert" from the tabs on the ribbon bar after selecting your data. Under the "Charts" area in the center, a list of the numerous chart choices that are accessible to you will appear.
- Use the "Insert Statistic Chart" option to browse a list of available charts.
- Tap the first chart choice on the left in the drop-down menu's "Histogram" section.
A histogram graphic will be added to your Excel spreadsheet as a result. Excel will make an effort to format the chart automatically, but once the chart is put, you may need to make manual adjustments.
How to Format a Histogram Chart
After you've added a histogram to your Microsoft Excel worksheet, you can edit it by right-clicking the labels of your chart's axis and selecting "Format Axis."
Although Excel will try to choose the bins (groupings) for your chart, you may need to modify them. For example, you could wish to divide the results into grade boundaries that appear in groups of ten for a list of student test scores out of 100.
By keeping the "By Category" option selected in the "Format Axis" menu on the right, you may maintain Excel's option for bin grouping. However, change to a different selection if you wish to modify these settings.
For instance, "By Category" will categorize your data using the first category in your data range. This would segregate each result for a list of student test results by the student, which wouldn't be as helpful for this sort of analysis.
You may divide your data into several groups using the "Bin Width" option.
By setting the "Bin Width" parameter to 10, you might divide the student test results in our example into groups of ten.
The lowest integer is used to begin the bottom axis ranges. Even if the highest test result number is still 100, the first bin grouping, for instance, is presented as "[27, 37]," and the most extensive range concludes with "[97, 107].
By specifying a certain number of bins to display on your chart, the "Number Of Bins" option may function similarly. For example, setting ten bins would likewise provide groups of 10 results.
The "Format Chart Area" tab on the right will provide standard formatting choices for your chart, such as altering the border and bar fill options.
Conclusion
You have read this article to understand more about histograms in Microsoft Excel. You created a histogram chart and changed the bin's value and range. Histograms are helpful when you need to assess a large amount of data swiftly.
