Part C:

Entering Data in a Worksheet and Creating a Bar or Column Graph that Compares 4 Groups per Category

It is quite easy using Chart Wizard to adapt a bar or column graph to compare more than 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 Men over 18 and Women over 18"

Data:

Average Hours Per Week of Television Viewing Comparing
Children 2-11, Adolescence 12 - 17, Men and Women 18 and Over
Canada 1999

1.

Add the data on Men 18 and Over and Women 18 and Over to the original Excel spreadsheet that already contains data on Children and Adolescence.

2.

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

a.

There are four series this time:
Label first series: Children 2 - 11
Label second series: Adolescence 12 - 17
Label third series: Men 18 and Over
Label fourth series: Women 18 and Over

b.

Labelling axis is still the same. You will see that for each province, you will have four 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 two graphs.

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, adolescence, men and women in each province.

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