Skip to main content
Make the most out of any wiki by using our free sister product,
Blendspace by TES
, to create interactive lessons and presentations!
Pages and Files
Creating a Graph in EXCEL
Before we can begin we need to collect some data that we will later display in our graph.
We are going to make a graph of the Hair Color of the Students in Our Class
You must first take a tally. List the following hair colors on a piece of paper.
Now look around the classroom and record a tally mark for each person in the class next to their color of hair.
Great! Now you have your data.
Count the tally marks and get a total for each color.
Moving to the computer.
You will need to open a new worksheet in Excel. This symbol
should be in your dock on the bottom of your screen.
If this symbol
is not in your dock, you will need to click on the finder
then click on applications
. Now you will scroll down to click on
. In the new menu double click
. You are now ready to begin
Once Excel is open it should look like this:
Type the name of the hair color in each of the boxes on the top line.
Now your worksheet will look like this:
Notice that you put all the color names in row 1.
Now in row 2, you are going to add your total tally marks for each hair color.
Your worksheet will look like this, but your numbers will be different from mine.
Now we are ready to make our graph. Since all of these students are in the same class, the class is our WHOLE. For this reason we are going to create a pie graph to display the haircolor of our WHOLE class.
First, click on Cell A1. That is the cell you typed Brown. Hold your clicker down while you drag your mouse across all the cells you have used.
It should look like this:
Great, pretty easy right. If you didn't get it the first time, just try it again.
Once you have the cells highlighted you will need to click on the graphing tool at the top of your screen.
It looks like this:
This will open a chart menu:
You will need to choose a PIE chart under the Chart Types:
Then click Next:
At the next screen, click
In the chart title box type: Hair Color
Click on Data Labels and check the Show Value Option:
And Now click Finish:
Using your graph, can you quickly tell me which hair color is the 2nd most common in your class?
Now that you have completed this graph, go back and using the same data, try to create another type of graph, such as a column or a bar graph. Just click on the graphing tool and click on a new type of graph. Excel will do the work for you.
Congratulations. You have learned how to create a graph using Excel! Wow, Way to go!
Animations for this page are from:
help on how to format text
Turn off "Getting Started"