Part B:

Entering Data in a Worksheet and Creating a Double Bar or Column Graph

It is quite easy using Chart Wizard to adapt a bar or column graph to compare two categories.

We can use the data from the previous chart and add to it data on "average hours per week of television viewing for adolescence ages 12 - 17".

Data:

Average Hours Per Week of Television Viewing Comparing
Children 2-11 and Adolescence 12 - 17
Canada 1999

1.

Add the data on Adolescence 12 - 17 to the Excel spreadsheet that already contains data on Children 2 - 11.

2.

Use Chart Wizard as you did in Part A of this assignment with several changes:

a.

There are two series this time:
Label first series: Children 2 - 11
Label second series: Adolescence 12 - 17

b.

Labelling axis is still the same. You will see that for each province, you will have two bars or columns.

c.

You may want to leave the legend on this graph, so do not deselect the legend.

d.

You will save this graph as a new chart, so as not to interfere with your last graph.

e.

You may want to experiment with changing textures or colours on your graph so that there is a contrast between the bars for children and adolescence in each province.

Get some help from your teacher if you are having trouble with this step.