

It consists of two bars, one for each item, that are compared. You can also add labels, a title, and gridlines to the graph.Ī double bar graph is a type of graph that is used to compare two different items. Here, you can change the color, width, and style of the bars. You can adjust the formatting of the graph by selecting it and clicking on the Design tab. Next, select the data in both columns and create a bar graph by clicking on the Insert tab and selecting the Bar button in the Charts group.Įxcel will automatically create a graph with two bars, one for each column of data. The first column should list the data points for the horizontal axis, and the second column should list the data points for the vertical axis. To create a double bar graph in Excel, you first need to create two columns of data in a spreadsheet. To this end, the merchants created a bar graph with which they were able to depict a wide variety of information pictorially which not only helped understanding but also made it easier from a merchant’s point of view. When the population was little, trade was fairly simple but keeping track of who owes whom how much (data), so on and so forth became extremely tedious. The merchants found it harder to keep track of the money flowing in and out of their coffers. Ultimately, the amount of data is also increased. As humanity flourished and the population increased, so did the amount of trade and transaction in the world. Pictorial representation of data is called pictograph. Here is where another characteristic of a bar graph comes into play. While discussing a bar graph, it was mentioned that the values are represented as a rectangular bar where the length of the rectangular bar is proportional to the value of the data. The same applies to the variety of soft drinks you consume. Similar expenses such as chocolates, candies, chewing gums are all grouped together. It is the first step to creating a bar graph. The first thing to observe is how the data is grouped.
