Plots data as horizontal bars representing stages in a process.
Values typically decrease from top to bottom so chart resembles a funnel.
Could be built using a stacked bar chart.
Data Format
- x-axis: Categories (e.g. countries or stage in a sales process)
- Categories are distributed evenly along the vertical axis.
- y-axis: Data Series (e.g. CO2 emissions per capita or # customers)
- Series are shown as horizontal rows for each category.
| Series | |
|---|---|
| Category 1 | # |
| Category 2 | # |
| Category 3 | # |
| Category 4 | # |
| Category 5 | # |
Try it now!
- Select a region using the dropdown list to view CO2 emissions in descending order by country.
- Note how the chart and title adjust to reflect the different values.
- This chart was built using data validation lists, named ranges, conditional statements and the IF, IFERROR, MATCH and OFFSET functions.
Related Waterfall, Funnel, Stock, Surface or Radar Charts
- Radar
- Stock (High, Low, Close)
- Stock (Open, High, Low, Close)
- Stock (Volume, High, Low, Close)
- Stock (Volume, Open, High, Low, Close)
- Surface
- Waterfall