Plots data in vertical columns stacked by category to represent 100%.
Emphasizes the contribution of two or more data series to the whole.
2D and 3D options are available.
Data Format
- x-axis: Categories (e.g. time series)
- Categories are distributed evenly along the horizontal axis.
- Becomes visually complex as more categories are added.
- y-axis: Data Series (e.g. population by age group)
- Series are distributed along the vertical axis and are stacked to represent 100%.
- Column length is displayed in percent (%) and totals 100% for all categories.
- Becomes visually complex as more series are added.
- Chart handles positive and negative values but interpretation can be difficult.
- Apply data labels judiciously or use a separate data table.
| Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | |
|---|---|---|---|---|---|
| Series 1 | # | # | # | # | # |
| Series 2 | # | # | # | # | # |
Try it now!
- Select a country/region using the dropdown list to view the split in urban and rural population figures.
- Note how the chart, title and sub-title adjust to reflect the different population values of each country/region.
- This chart was built using data validation lists, named ranges, conditional statements and the COUNTIF, IF, IFERROR, MATCH, OFFSET and RANK functions.
Related Column and Bar Charts