Table of Contents
Pictorial Representation Using Bar Graph
A bar graph also known as a bar chart is a chart that presents data that is grouped into rectangular bars. Here the length of the bar is directly proportional to the values they represent. The bar graph can be drawn vertically or horizontally. A vertical bar graph is known as a Column Bar Graph. Since one bar graph can be used to display multiple groups of data on the same graph, bar graphs can also be used as comparative tools where the length of the rectangular bar represents the value of each category. Since the rectangular bars are proportional, their differences can be spotted much more easily, visually than through words. Let’s take a closer look at bar graphs.
Say you have pocket money of 100 rupees every week. You are allowed to spend this amount any which way you want to. You use this money to buy chocolate, beverages, food and other miscellaneous toys and stuff. What you notice is that every week, the money just seems to disappear. You ask your father for a little more money but he instead suggests that you see where the money is going so that you can learn the value of money. To this end, you grudgingly make a bar chart. But to create a bar chart, you need to have data. You need to note down the things you are spending money on and how much. After a week you have the details of this week’s expenditure and they look something like this
| Items | Week 1 |
| Chocolate | 25 |
| Beverages | 20 |
| Food | 40 |
| Misc | 15 |
The first thing to observe is how the data is grouped. It is the first step to creating a bar graph. Similar expenses such as chocolates, candies, chewing gums are all grouped together. The same applies to the variety of soft drinks you consume. 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. Here is where another characteristic of a bar graph comes into play.
Pictorial representation of data is called pictograph. As humanity flourished and the population increased, so did the amount of trade and transaction in the world. Ultimately, the amount of data is also increased. The merchants found it harder to keep track of the money flowing in and out of their coffers. 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. 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. What is the Bar Graph? Let’s find out.
How to Make a Double Bar Graph in Excel
To create a double bar graph in Excel, you first need to create two columns of data in a spreadsheet. 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.
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.
Excel will automatically create a graph with two bars, one for each column of data. You can adjust the formatting of the graph by selecting it and clicking on the Design tab. Here, you can change the color, width, and style of the bars. You can also add labels, a title, and gridlines to the graph.
What is a Double Bar Graph ?
A double bar graph is a type of graph that is used to compare two different items. It consists of two bars, one for each item, that are compared. The height of the bar represents the amount of that item.
How to Make Double Bar Graph on Graph Paper
To make a double bar graph on graph paper, first draw a horizontal line across the middle of the paper. This will be the x-axis. Then, draw a vertical line down the middle of the paper. This will be the y-axis.
Next, draw the bars for the graph. For the x-axis, draw one bar on the left side of the horizontal line and one bar on the right side of the line. For the y-axis, draw one bar at the bottom of the vertical line and one bar at the top of the line.
Finally, fill in the data for the graph. For the x-axis, write the labels “Male” and “Female” on the bars. For the y-axis, write the labels “Number of Children” and “Number of Pets” on the bars.
Double Bar Graph Examples
Example 1
This bar graph shows the number of students in each grade level at a school.
Example 2
This bar graph compares the number of students in each grade level at two schools.
