Creating a Column Chart

If you were to ask the students what pets they had at home, you might come up with the following results:

  • Dog 9
  • Cats 3
  • Fish 9
  • Birds 4
  • Gerbils 2
  • Reptiles 1

To create a graph that represents this data, start Microsoft Excel. Click in the first cell (A1) and type the word Dog. Press the Tab key( on the left side of the keyboard), that will move you to the right one cell. Type the number 9 and press Return(Enter). That should move you down to cell A2, enter the word Cat. Continue the sequence untill all the data has been entered.