Creating Graphs - 1 CREATING GRAPHS IN MICROSOFT EXCEL 2007...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
CREATING GRAPHS IN MICROSOFT EXCEL 2007 By Tiffany Zeleznikar M.A. University of Phoenix, Faculty 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Always separate your data based on the range of scores/data values. Always put them in order from top to bottom of lowest value/score to highest. See how I did it in column C. Then you will put the frequency next to that. So I had 3 scores of a 60 on an exam so I say the grade is 60, the frequency was 3. Once done entering the data click on the Insert Tab 2
Background image of page 2
Click on the Column option, and select the first option: Clustered Column. 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Once you click that graph you will get a very silly looking graph. So we are going to have to fix the graph. 4
Background image of page 4
Right click on a clear spot on the graph and scroll down to “Select data…” click on it. 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
the graph that you shouldn’t have. Try again until you get this box. Now you will notice that everything is selected this is no good. Click on the little red/blue icon on the box for the next step we are going to select the data that we want. 6
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Creating Graphs - 1 CREATING GRAPHS IN MICROSOFT EXCEL 2007...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online