- What is a Bar Chart?
- Bar Chart vs. Histogram
- Bar Graph Examples (Different Types)
- How to Make a Bar Chart:
Watch the video for a few examples:
Can’t see the video? Click here.
A bar chart is a graph with rectangular bars. The graph usually compares different categories. Although the graphs can be plotted vertically (bars standing up) or horizontally (bars laying flat from left to right), the most usual type of bar graph is vertical.
The horizontal (x) axis represents the categories; The vertical (y) axis represents a value for those categories. In the graph below, the values are percentages.
A bar graph is useful for looking at a set of data and making comparisons. For example, it’s easier to see which items are taking the largest chunk of your budget by glancing at the above chart rather than looking at a string of numbers. They can also shows trends over time, or reveal patterns in periodic sequences.
Bar charts can also represent more complex categories with stacked bar charts or grouped bar charts. For example, if you had two houses and needed budgets for each, you could plot them on the same x-axis with a grouped bar chart, using different colors to represent each house. See types of bar graphs below.
Watch the video for an example of how to make a bar chart by hand:
Although they look the same, bar charts and histograms have one important difference: they plot different types of data. Plot discrete data on a bar chart, and plot continuous data on a histogram What’s the difference between discrete and continuous data?).
A bar chart is used for when you have categories of data: Types of movies, music genres, or dog breeds. It’s also a good choice when you want to compare things between different groups. You could use a bar graph if you want to track change over time as long as the changes are significant (for example, decades or centuries). If you have continuous data, like people’s weights or IQ scores, a histogram is best.
A bar graph compares different categories. The bars can be vertical or horizontal. It doesn’t matter which type you use—it’s a matter of choice (and perhaps how much room you have on your paper!).
List of Types
A grouped bar graph is a way to show information about sub-groups of the main categories.
In the above image, the categories are issues that senior citizens face (hearing loss and mobility issues); the sub-groups are age. A separate colored bar represents each sub-group: blue for age 70-79 and red for age 80-100.
A key or legend is usually included to let you know what each sub-category is. Like regular bar charts, grouped bar charts can also be drawn with horizontal bars.
When there are only two sub-groups (as in the above image), the graph is called a double bar graph. It’s possible to have as many sub-groups as you like, although too many can make the graph look cluttered.
A stacked bar chart also shows sub-groups, but the sub-groups are stacked on the same bar.
Each bar shows the total for sub-groups within each individual category.
Like the double bar chart, different colors represent different sub-groups. This type of chart is a good choice if you:
- Want to show the total size of groups.
- Are interested in showing how the proportions between groups related to each other, in addition to the total of each group.
- Have data that naturally falls into components, like:
- Sales by district.
- Book sales by type of book.
Stacked bar charts can also show negative values; negative values are displayed below the x-axis.
Back to Top
A type of stacked bar chart where each bar shows 100% of the discrete value. They should represent 100% on each of the bars or else it’s going to be an ordinary stacked bar chart. For more on this particular type of graph, see: Segmented Bar Charts.
Need help with a homework question? Check out our tutoring page!
If you’re just starting to learn how to make a bar graph, you’ll probably be asked to draw one by hand on graph paper at first. Here’s how to do it.
Example problem: Make a bar graph that represents exotic pet ownership in the United States. There are:
- 8,000,000 fish,
- 1,500,000 rabbits,
- 1,300,000 turtles,
- 1,000,000 poultry
- 900,000 hamsters.
Step 1: Number the Y-axis with the dependent variable. The dependent variable is the one being tested in an experiment. In this example question, the study wanted to know how many pets were in U.S. households. So the number of pets is the dependent variable. The highest number in the study is 8,000,000 and the lowest is 1,000,000 so it makes sense to label the Y-axis from 0 to 8.
Step 3: Label the X-axis with what the bars represent. For this example problem, label the x-axis “Pet Types” and then label the Y-axis with what the Y-axis represents: “Number of pets (per 1,000 households).” Finally, give your graph a name. For this example, call the graph “Pet ownership (per 1,000 households).
Optional: In the above graph, I chose to write the actual numbers on the bars themselves. You don’t have to do this, but if you have numbers than don’t fall on a line (i.e. 900,000), then it can help make the graph clearer for a viewer.
- Line the numbers up on the lines of the graph paper, not the spaces.
- Make all your bars the same width.
A small quirk with Excel: Excel calls vertical graphs column charts and horizontal graphs bar charts.
Example problem: Create a bar chart in Excel that illustrates the following data for the tallest man-made structures in the world (as of January, 2013):
|Building||Height in feet|
|Burj Khalifa, Dubai||2,722|
|Tokyo Sky Tree||2,080|
|KVLY-TV mast, US||2,063|
|Abraj Al Bait Towers, Saudi Arabia||1,972|
|BREN Tower, US||1,516|
|Lualualei VLF transmitter||1,503|
|Petronas Twin Tower, Malaysia||1,482|
|Ekibastuz GRES-2 Power Station, Kazakhstan||1,377|
|Dimona Radar Facility, Israel||1,312|
|Kiev TV Tower, Ukraine||1,263|
|Zhoushan Island Overhead Powerline Tie, China||1,214|
Step 1: Type your data into a new Excel worksheet. Place one set of values in column A and the next set of values in column B. For this example problem, place the building names in column A and the heights of the towers in column B.
Step 2: Highlight your data: Click in the top left (cell A1 in this example) and then hold and drag to the bottom right.
Step 3: Click the “Insert” tab and then click on the arrow below “Column.” Click the type of chart you would like (for example, click “2D column).
Tip: To widen the columns in Excel, mouse over the column divider, click and drag the divider to the width you want.
Back to Top
Watch the video or read the steps below. Plus, learn some basic formatting tips:
A bar graph in statistics is usually a graph with vertical bars. However, Excel calls a bar graph with vertical bars a column graph. If you want to make a column chart (vertical bars), watch this other video on my Youtube channel, How to make a column chart in Excel 2013 (also works for 2016).
Step 1: Click the “Insert” tab on the ribbon.
Step 2: Click the down arrow next to the bar chart icon.
Step 3: Select a chart icon. For example, select a simple bar chart.
How to make a bar graph in Excel 2016/2013: Formatting tips
- Change the width of the bars: Click on a bar so that handles appear around the bars. Right click, then choose Format Data Series. Under Format Data Series, click the down arrow and choose “Series Options.” Click the last choice (“Series…”). Then move the “Gap Width” slider to change the bar width.
- If you want to remove the title or the data labels, select the “Chart Elements icon.” The Chart Elements icon is the first icon showing at the upper right of the graph area (the + symbol).
- Change the style or color theme for your chart by selecting the Chart Styles icon. The Chart Styles icon is the second icon showing at the upper right of the graph (the pencil).
- Edit what names or data points are visible on the chart by selecting the filter icon. The filter icon is the third icon at the top right of the chart area.
Step 1:Select the data in your worksheet. The names for each bar are in column A. The “stacked” portion of each bar are in the rows.
Step 2: Click the “Insert” tab, then click “Column.”
Step 3: Choose a stacked chart from the given options. For example, the second chart listed (under 2-D column) is a good choice.
If you want to modify the layout of your chart, click the chart area of the chart to display the Chart Tools in the ribbon. Then click the “Design” tab for options.
Back to Top
Minitab is a statistical software package distributed by Minitab, Inc. The software is used extensively, especially in in education. It has a spreadsheet format, similar in feel to Microsoft Excel. However, where it differs from Excel is that the toolbar is set up specifically for creating statistical graphs and distributions. Creating a bar graph in Minitab is as simple as entering your data into the spreadsheets and performing a couple of button clicks.
This video below walks you through the steps:
Can’t see the video?