How to create a histogram chart
The histogram chart lets you automatically group data values in intervals you specify, it is often used in statisticsĀ to show how data is distributed.
How to build
- Select data.
- Go to tab "Insert" on the ribbon.
- Press with left mouse button on the "Statistic chart" button.
- Press with left mouse button on the "Histogram" button.
- Double-press with left mouse button on the x-axis to open the task pane.
- Select "Bin width:" and type 5, you may have to try different values here depending on the data you have.
- "By Category" allows you to use text values, Excel will count text strings and plot the chart based on the number of text strings.
- Automatic is the default setting. The intervals are created evenly based on the minimum and maximum value.
- "Bin width" allows you to specify the range you want to use.
- Select "Number of bins" if you want to specify the number of intervals to use.
- Select "Overflow bin" and "Underflow bin" to create an interval for all values above/below a threshold.
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.