• HOW TO MAKE A GRAPH WITH EXCEL
     
    1.  ENTER YOUR DATA INTO TWO ADJACENT COLUMNS (X-Y).

    2.  HIGHLIGHT THE ALL THE INFORMATION YOU JUST ENTERED.

    3.  CHOOSE THE CHART WIZARD FROM THE TOOLBAR.

     

    4.  CHOOSE XY (Scatter).  Click Next >.

    5.  BE SURE THAT COLUMNS ARE SELECTED FOR YOUR SERIES IN: OPTION.  CLICK NEXT >.

    6.  CHANGE YOUR TITLE TO SOMETHING MEANINGFUL.  INSERT THE UNITS FOR THE X-AXIS AND THE Y-AXIS IN THE VALUE (X OR Y) AXIS: BOXES. 

    7.  CHOOSE THE GRIDLINES TAB.  IF THE GRAPH WILL BE USED FOR INTERPOLATION/ EXTRAPOLATION, CLICK BOTH THE MAJOR AND MINOR GRIDLINES BOXES. 

    IF THE GRAPH WILL ONLY BE USED FOR SHAPE / RELATIONSHIP, ONLY CHOOSE THE MAJOR GRIDLINES BOX. 

    8.  CHOOSE THE LEGEND TAB.  UNLESS YOUR LEGEND IS ACTUALLY MEANINGFUL, REMOVE IT BY REMOVING THE CHECK MARK IN THE SHOW LEGEND BOX.

     

    9. CHOOSE THE DATA LABELS TAB.  TO PUT THE VALUES BESIDE THE DATA POINTS, CHOOSE THE X VALUE AND THE Y VALUE BOXES.  MAKE THE SEPARATOR , (COMMA).

     

    10.  CHOOSE AS OBJECT IN: WHATEVER SHEET YOU ARE USING.  THIS WAY, THE GRAPH WILL JUST FLOAT OVER YOUR DATA.  CLICK FINISH. 

    11.  STRETCH THE GRAPH OUT NICE AND BIG BY GRABBING A CORNER HANDLE (BLACK SQUARE), CLICK AND HOLD, AND DRAG DIAGONALLY UPWARD. 

    12.  RIGHT-CLICK ON ONE OF THE DATA POINTS.  YOU MUST HIT A DATA POINT EXACTLY.  CHOOSE ADD TRENDLINE... TO GET A LINE OF BEST FIT. 

    13.  CHOOSE THE SHAPE THAT LOOKS TO BEST FIT YOUR DATA, OR THE ONE THAT YOU KNOW SHOULD FIT YOUR DATA.  CHECK WITH MR. NEFF OR YOUR BOOK IF YOU AREN'T SURE.

    14.  CLICK THE OPTIONS TAB.  TO DISPLAY THE EQUATION OF THE LINE ON THE GRAPH, CHOOSE THE DISPLAY EQUATION ON CHART BOX.

     


    15.  YOU SHOULD NOW SEE A LINE OF BEST FIT THROUGH YOUR DATA.  YOU CAN DRAG THE EQUATION OVER THE WHITE SPACE TO MAKE IT EASIER TO READ. 

    16.  YOU CAN PRINT JUST YOUR CHART BY CLICKING ON THE CHART FIRST, AND THEN CHOOSING PRINT:

    OR YOU CAN PRINT THE WHOLE PAGE BY CLICKING OFF OF THE CHART.

    17.  TO ADD INTERPOLATION/EXTRAPOLATION LINES, YOU'LL NEED THE DRAWING TOOLS.  TO DISPLAY THEM, RIGHT CLICK ON ANY TOOLBAR.

    18. CHOOSE THE "DRAWING" TOOLBAR.  YOU WILL SEE THE DRAWING TOOLS POP UP, PROBABLY SOMEWHERE AT THE BOTTOM OF YOUR SCREEN. 
    (NOTE: IF "DRAWING WAS ALREADY CHECKED, YOU ALREADY HAVE YOUR DRAWING TOOLS UP.  DON'T RESELECT THEM, BECAUSE YOU'LL TURN THEM OFF.)

    19.  NOW, CHOOSE THE "LINE" TOOL FROM THE DRAWING TOOLBAR BY CLICKING IT ONCE.  IT IS RIGHT BESIDE "AUTOSHAPES".  YOUR MOUSE WILL TURN INTO A CROSSHAIR. 

    20.  NOW, FOR INSTANCE, IF YOUR UNKNOWN FORCE CAUSED AN ACCELERATION OF 11.5 M/S/S, YOU WOULD START DRAWING YOUR INTERPOLATION LINE AT 11.5 M/S/S ON THE ACCELERATION AXIS (X-AXIS). 
    CLICK AND ON THE AXIS AT 11.5, HOLD DOWN THE MOUSE BUTTON AND DRAG UPWARD UNTIL YOUR LINE TOUCHES THE TRENDLINE.

          

    21.  NOW TO FIND THE CORRESPONDING VALUE OF THE OTHER VARIABLE, DRAW ANOTHER LINE FROM WHERE YOUR LINE TOUCHED THE TRENDLINE TO THE OTHER AXIS.  WHERE THE INTERPOLATION LINE INTERSECTS WITH THE AXIS IS YOUR EXPERIMENTAL VALUE OF YOUR UNKNOWN QUANTITY.

        

    22.  IF YOUR INTERPOLATION LINE DOES NOT SHOW UP VERY WELL (AS ABOVE) YOU CAN DO ONE OR TWO OF TWO THINGS:

        YOU CAN MAKE YOUR LINE THICKER:

            SELECT YOUR INTERPOLATION LINE

           

            CHOOSE LINE STYLE

            SELECT A THICKER LINE WIDTH.  BE CAREFUL NOT TO MAKE YOUR LINE TOO THICK, IT WILL LOOK LIKE YOU ARE TRYING TO HIDE SOMETHING.

    YOUR LINE WILL NOW BE THICKER.

         OR YOU CAN MAKE YOUR LINE A DIFFERENT COLOR:

                SELECT YOUR INTERPOLATION LINE

           

                    CLICK THE DROP DOWN ARROW BESIDE THE LINE COLOR 

                CHOOSE A DIFFERENT COLOR.

            YOUR LINE WILL NOW BE A DIFFERENT COLOR. 

     

    NOW GO BACK TO STEP 16 TO PRINT YOUR GRAPH.

     

     
     
    23.    WHEN EXTRAPOLATING, SOMETIMES YOU NEED TO EXTEND THE DOMAIN AND RANGE OF THE GRAPH.  TO EXTEND THE DOMAIN, DOUBLE CLICK IN THE VICINITY OF THE X-AXIS OR ONE OF THE X-AXIS NUMBER LABELS (SEE PICTURE).

     

    24.    CLICK ON THE “SCALE” TAB.  UNDER MAXIMUM, PUT A VALUE SLIGHLTY HIGHER THAN THE VALUE YOU WANT TO EXTRAPOLATE.  CLICK “OK.”

     

     

    25.    NOW, YOU’LL SEE THAT YOUR GRAPH HAS BEEN REFORMATTED, TO SHOW THE DOMAIN YOU CHOSE. 

     

     

    26.    CHANCES ARE, YOU’LL HAVE TO RE-SCALE THE Y-AXIS TOO.  YOU CAN DO THAT THE SAME WAY AS YOU DID THE X-AXIS. 

           

     

    27.    NOW, TO EXTRAPOLATE, YOU WILL PROBABLY NEED TO EXTEND YOUR TRENDLINE FORWARD OR BACK.  TO DO SO, DOUBLE CLICK ON THE TRENDLINE ITSELF.  (THIS IS TRICKY TO DO; YOU HAVE TO BE RIGHT ON IT.  IF YOU MISS, YOU’LL GET THE “FORMAT GRIDLINES” BOX, INSTEAD OF THE “FORMAT TRENDLINE” BOX.)

     

    28.    IN THE “FORMAT TRENDLINE” BOX, CLICK ON THE “OPTIONS” TAB.  IN THE “FORCAST” SECTION, INPUT HOW MANY UNITS YOU’D LIKE TO EXTEND YOUR TRENDLINE FORWARD, OR HOW MANY UNITS YOU’D LIKE TO EXTEND IT BACKWARD.  

     

    29.    TO ADD INTERPOLATION/EXTRAPOLATON LINES, GO ONTO STEP 17, OR GO BACK TO STEP 16 TO PRINT YOUR GRAPH .

     

     

Last Modified on August 27, 2011