Exceljet

Quick, clean, and to the point

Top 15 Countries by Life Expectancy

Example bar chart - 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:

Data used to create life expectancy chart


How to make this chart

  1. Hold down control key and select ranges as shown above
  2. Click the insert column icon at Insert > charts
    Insert > column chart via ribbon
  3. Select the first 2d option
    Select first 2d bar chart
  4. The chart as inserted
    Initial bar chart as inserted
  5. Select vertical axis; reverse sort order and set interval to 1
    Select axis and reverse sort order
  6. Add data Labels
    Add data labels
  7. Select data series and set bar width
    Set series overlap and gap width
  8. Select and delete gridlines
  9. Select and delete horizontal axis
  10. Set title as desired
  11. Final chart after changes
    Final bar chart after changes


 

Chart type 
Author 
Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.