Lesson#89: Example of bar chart with life expectancy data

Hello reader. This post is a discussion about an example of bar chart making with life expectancy data of all countries.

Here I am having data in 4 columns. Country, Both sexes life expectancy, Female life expectancy, Male life expectancy. I will represent this data with help of a bar chart.

In a different sheet you go to Insert>Charts>Bar Chart

A blank chart will appear like the above picture. There you right click on the blank chart and click on Select Data.

Click the button beside Chart data range 

There you have select the data including the column headings.

And the chart will appear like this. There you have to make some changes. You have to increase the chart area by dragging the corner to down and you can change the layout.

You can add fields to chart by clicking the “+” button at upper right corner of chart or

You can click on Quick Layout to change the layout of the chart.

So I have shown you how to make a bar chart. More different types of chart examples I will show in my next posts.

Puspendu is the founder author of Excelabcd. He is a creative person, blogger and Excel-maniac guy.

Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *