Steps to Compare Items in MS Excel Using Bars

Step 1: Let’s Take a set of data, which you will want to compare using a Column chart.

Step 2: Select the whole data then go to the insert tab and from the “Charts” group choose “Insert Column or Bar Chart”.

Step 3: From “Charts” group select  > “Insert Column or Bar Chart” > Choose 2-D Bar.

Step 4: You can Give the name of Both the Axis and Chart also, for that click once on “Chart Area“(Background area of the charts) then choose “Chart Elements” and select the “Axis Titles“. 

Step 5: Rename both axis titles as items and months respectively and chart titles as online summer sales.

Step 6: For a better look at Charts, you can choose different styles and colors, for that, click once on Chart area > choose “Chart Styles” >  Select different Styles and Colors.

Step 8: At the final, it looks like the image, mentioned below:

A Column chart is a type of chart in which data are shown using vertical bars. In the Column chart, categories are displayed along the horizontal axis(x-axis) and values are on the vertical axis(y-axis).  It is useful for the comparison of different types of items of data in a very clear and understandable way. By using Column charts we can easily compare different things among different items of data, and we can justify whether the products/sales/price/etc. of different items are going upward or downward and able to find any relation between them. In a simple way, we can say that vertical charts are known as Column charts.

A Bar chart is a type of chart in which data are shown using horizontal bars. In the Bar chart, categories are displayed along the vertical axis(y-axis) and values are on the horizontal axis(x-axis).  It is useful for showing segments of information and comparing different items of data in a more clear way. In a simple way, we can say that horizontal charts are known as Bar charts.