A bar chart is one of Excel's primary chart types and a good choice for categorical data. Bar charts plot data using horizontal bars, so they are very easy to read because the human eye can easily compare bars. Also, because of the horizontal layout, bar charts have room to accommodate longer category names.
Bar charts are also versatile. They can be used to plot both nominal data and ordinal data, and they can be used instead of a pie chart to plot data with a part-to-whole relationship. If you're trying to decide on a chart type, a bar chart is a good first choice.
- Very easy to read
- Easy to add data labels at ends of bars
- Room for longer text labels
- Become cluttered with too many categories
- Clustered bar charts are harder to read as data series are added
- Add data labels where when it makes sense
- Sort bars by largest to smallest (unless data has a natural sequence)
- Avoid all 3d options
Top 15 Countries by Life Expectancy
Which countries have the longest life expectancy? Bar charts work well for this kind of data because (1) the bars are easy to compare and (2) there is plenty of room for labels on the vertical axis.
Here is the data used to plot this chart: