Hand-In Assignment:

Use Information from a Web site to Create a Bar or Column Graph Using Excel Spreadsheet and Chart Wizard

In this hand-in assignment, you will go to a Statistics Canada Website and get some data. You will produce a bar or column graph by setting up a spreadsheet and using Chart Wizard.

1.

1. Go to the website: http://www.statcan.ca/english/Pgdb/People/Labour/labor01a.htm

2.

There you will see the heading: Average earnings by sex and work pattern You can select: all earners, full-time workers, other workers.
Select: all earners
You will see the following data chart.

3.

Set up an Excel spreadsheet and enter the data in the chart. Enter Year, Men, Women. Do not enter Earnings Ratio %.

4.

You must Format the dates as Text. To do this:

a.

Select the range of cells in the Dates column

b.

Select Format on the Excel toolbar, then Select Cells, then Number and then Text.

If you follow those steps, your Dates column will be formatted as Text. If you have been unsuccessful, you will see three columns or bars for each date. Get help from your teacher if this occurs.