Graph Lesson 2 - Use Excel to Create Graphs in Your Classroom

Educational Resources

Free Phonics Games
Can't Find Something... Search my whole site
Doubles Plus One Game
Doubles Plus Two Game
Calculator Game
Free Subtraction Game
Roman Numerals
Math Site Review
Numeration Game
Decimal Game

Line Symmetry

Prime Number Charts
2d Shape Game
3D Shape
3d Shape Nets
Problem Solving Activities
Cubic Metre Lesson
Fun Graphs Lesson

Math Game Homepage - Graph Activity - What pets do we have?


classroom graphing idea
You can use Excel to create graphs like this.

NB This tutorial was made in 2003. Google Sheets would be your go to now :-)

Step 1 - Start Excel & then Insert your data into columns A & B.

Make sure you leave row 1 blank.

classroom graphing idea

classroom graphing idea 

Step 2 - Highlight all your data in both columns by left clicking in the top right hand corner of cell A1 and dragging to the bottom right hand corner.

classroom graphing idea

Step 3 - Press the Chart Wizard button to convert the data into a graph.

graphing with excel

Step 4 - Choose a graph that WILL communicate the meaning of the data effectively. (Not just pretty pictures)

Step 5 - Press 'Next'

graphing with excel

graphing with excel

Step 6 - Write in the title of your graph and press 'Next'

Step 7 - Right click on any column and choose 'Format Data Series' then choose the colours of the graph.

graphing with excel

graphing with excel

Step 8 - Right click on the Wall, choose 'Format Walls' & select a colour.

- You can also format the floor of the graph by right clicking on the floor & formatting it.

Excel Graphing Activity
Excel Graph Activity
Acrobat Version - 185k

More Cool Math Games


FREE Math Games

More Printable Reading Games

Reading Program
to Try

Free Math and Reading Games


Fractions Games

Number Sense Games


for Kids

Problem Solving Puzzles Printable