TV Set

Bar Charts

Graph It In Excel

Introduction

Bar charts are used for (relative) frequencies in classes of categorical variables, or for discrete data. For example, numbers of people in different ethnic groups, or number of people with different numbers of siblings.

Key properties

The basic bar chart can be extended when we have more than one variable to display:

Example

Ethnicity and sex of a small sample of New Zealanders.

EthnicityFemalesMalesTotal
European8373156
Maori141024
Other4913
Pacific617
Overall200
(Source: SURF for Schools: Income survey, Statistics New Zealand)

The data tabled above can be represented as bar charts:

Clustered bar chart
   
Stacked bar chart

Video 1


This video shows how to create a simple bar chart.

This video requires a browser capable of HTML5 or Flash video.

Video 2


Building on knowledge gained in the first video, this second video shows how to make clustered and stacked bar charts.

This video requires a web browser capable of HTML5 or Flash video.

Documents


There are two files associated with this lesson:

<< Back to Table of Contents