Bar graphs in Excel are a form of charts and are to be inserted in the same manner. Bar graphs could be both 2-dimensional and 3-dimensional depending upon the type of Excel editor you use.
How to create a Bar Graph in Excel
To create a bar graph in Excel: Usually, the location and size of the chart are centered. You can adjust both these parameters according to your needs. Eg. Let us say we are provided with a set of data of the marks by students in a class. The data is further extended across various subjects. This makes the data complex because to compare between the students, you would have to literally pick each value from the list, highlight the row and column one by one and check which student scored what in which subject.
So, select the data from range A1 to G7 and go to Insert > Bar Graph. Select the appropriate bar graph and change the location and size.
The subjects have been mentioned across Y-axis and the percentages across X-axis.
The names of the students have been mentioned using colors. Now you can easily compare students on the basis of their marks scored in each subject.
How to make a Column Chart in Excel
Alternatively, you could create a column chart. The procedure is similar to that for a bar graph as explained earlier, however, this time select Insert > Column and then choose the chart type. A column chart makes details even clearer as you can simply compare the marks of 2 students by observing the respective heights of the columns. A column graph for the above-mentioned example has been shown in the image below. However, it should be noted that this graph is static. You can also choose to create a dynamic chart in Excel. Hope it helps!
