Bar chart

Plot both nominal and ordinal data.
x-axis: Categories (e.g. countries)
- Categories are distributed evenly along the vertical axis.
- Ideal for data with longer category names.
- Chart handles multiple categories but can be difficult to read when too many categories are added.
y-axis: Data Series (e.g. per capita CO2 emissions)
- Series are distributed evenly along the horizontal axis.
- Bar length shows scale of categories.
- Sort bars from largest to smallest where valid to make chart easier to read.
- Reordering the bars can change interpretation.
- Chart handles positive and negative values.
- Apply data labels judiciously, either inside or outside of the bars.

Select a region from the dropdown list to view the countries with the highest per capita CO2 emissions.
Note how the chart and title adjust to reflect the different data values of each region.

This chart was built using data validation lists, named ranges, conditional statements and the COUNTIF, IF, IFERROR, MATCH, OFFSET and RANK functions.

Rating:

( 0 Rating )