Graphing Using Excel Sample Problem
Mr. DeHoratius



  1. Launch the Excel program, which is part of the Office suite of programs;
  2. enter the following data starting at the upper left of the grid, making sure that you bold the titles of each column;



  3. Select the temperature column, including the word temperature, by positioning your cursor over the word temperature, clicking and holding the mouse button and dragging down to the last number in the column. Your data should look like the data below.



  4. Click on the chart wizard in the toolbar and you will see the window shown below:



  5. Be sure to click on the line choice in the left box and, on the right, the graph in the second row, second column.


  6. Click on the next button and you will see the window below:




  7. Click on the Series tab near the top and you will see:




  8. At the bottom of the window you see the words, “Category (X) axis labels:” followed by and empty box and then an icon. Click on that icon and you will be returned to your data on the spreadsheet but you will also have a small window that will look like the following:







  9. Click and drag down the time column -- do NOT include the word time -- only the measurements. The small window will now look like the following:




  10. Click on the icon to the right of this small window and you will be returned to the chart wizard window that looks like the following:





  11. Click on the next button in the above window and you will see the following window:




  12. Fill in the Chart title box as indicated above and the Category (X) axis: box as indicated above; then clock on the next button and you will see the following window:




  13. be sure the radio button to the left of the words “As object in:” is blackened by clicking on the radio button; then click on the finish button. You should then see the following graph along with your data table;





  14. Click somewhere in the area of the graph and your cursor should change to a hand; drag the graph under the data so that it does not obscure any of the data.


  15. Click anywhere outside of the area of the graph so that the small black squares disappear at the corners of the graph and along the midpoints of each side.


  16. Go to the file menu at the top and go down to “page setup” and you will see the following window:




  17. Click on the “Header/Footer” tab at the top and you will see the following window:





  18. Click on the “Custom Header” button and you will see the following window:




  19. Your cursor should be in the left section; type your full name and then select your name by clicking and dragging your cursor over your name; your window should look like the following:


  20. Click on the button that has the “A” on it; this is the text button; you will see the following window:



  21. Click on the word “Bold” in the center section and then click on the OK button; you will be returned to the window above item 20 above but your name should be bolded; the window should look like the following:



  22. As indicated above move your cursor to the center section by pressing the tab key, and then type the word problem followed by a space followed by the number symbol (shift 3) and, in this case the word sample; press the tab key to move your cursor to the right section and type today’s date; then press the OK key and you will see the following window or something similar to it; if you do not see the exact window click on the “Sheet” tab at the top of the window;



  23. Place your cursor over the box to the left of the word gridlines and click once; you should see a check mark appear in the box and the window should look like the following:



  24. Click on the OK button and you will be returned to your spreadsheet/graph. Be sure to save the file before trying to print.

  25. Print your data/graph and both should be on the same sheet.


  26. You must finish this before you leave the computer lab.