Plots the distribution of data grouped into frequency bins.
Bin width or count can be adjusted.
Data is shown as continuous with no gaps between bins.
Data Format
- x-axis: Categories (e.g. countries)
- Categories are grouped by values into frequency bins.
- Categories themselves are not shown on chart.
- y-axis: Data Series (e.g. unemployment rates)
- Series are shown in vertical columns as the proportion of values in each bin.
- Chart handles positive and negative values.
| Series | |
|---|---|
| Category 1 | # |
| Category 2 | # |
| Category 3 | # |
| Category 4 | # |
| Category 5 | # |
Try it now!
- Select a region using the dropdown list to view the distribution of unemployment rates.
- Note how the chart and title adjust to reflect the different time periods and values.
- This chart was built using data validation lists, named ranges, conditional statements and the AVERAGE, IF, IFERROR, MATCH, MAX, MEDIAN, MIN, MODE, OFFSET and TEXT functions.
Related Statistics Charts