Plots the distribution of data grouped into sorted frequency bins.
Shows the biggest factors in a set of data (e.g. per the 80/20 Pareto principle).
Includes a line representing cumulative contribution to 100% of each column.
Limited formatting options compared to a Combo chart.
Data Format
- x-axis: Categories (e.g. countries)
- Categories are grouped by values into frequency bins.
- Bins are sorted in descending order.
- Categories themselves are not shown on chart.
- y-axis: Data Series (e.g. mobile cellular subscriptions)
- Series are shown in vertical columns as the proportion of values in each bin.
- Chart handles positive and negative values.
- Bins are plotted to the primary axis; the line to the secondary axis.
| 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 cellular mobile subscriptions per 100 people.
- 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 IFERROR, MATCH and OFFSET functions.
Related Statistics Charts