Start the Excel program.

Rows go across the screen. Columns go down the screen.

The squares in the grid are called cells. Each cell has a name -- a letter and a number.

Click in the cell B1. Type '3' and press 'Enter'. Fill in the cells B2 to B5 with the data from Table 1. We need to say what the data means, so fill in cells A1 to A5 with the names of the flavours. The screen should look like the picture when you have finished.

We need to select which data to use. Click in cell A1 and hold down the mouse button. Move to cell B5 and release the button. It should look like the picture.

Click on the 'Chart Wizard' icon; It looks like this:

In the box that pops up make sure that 'Column' is highlighted,

then click on the 'Next' button. 

You should see a picture of what the chart will look like. Just click on 'Next' again.

You need to fill in the title and labels for the chart. Click in the first box and type the title. The other boxes are for the labels along the bottom and the side. When you are finished click on 'Next'.

Click on 'Finish'. 

Your bar chart is now completed. Ask your teacher how to delete it.

1. Make a pie chart from the same data (Table 1).
2. Make a bar (column) chart and a pie chart from Table 2. Which is the best?
3. Make a bar (column) chart and a pie chart from Table 3. Which is the best?
4. Extension: Experiment with some of the other charts and graphs you can make from the data. See if you can make a scatter graph from Tables 2 & 3.

Table 1 -- Favourite ice cream flavour

Table 2 -- Population of selected countries (millions)

Table 3 -- GNP per person (US$) (selected countries)