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 Versatile 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

Links Here is the data used to plot this chart: …Read more Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Bar chart - 88Bar chart - 59Bar chart - 46Bar chart - 95Bar chart - 90Bar chart - 93Bar chart - 44Bar chart - 53Bar chart - 60