Computer Generated Graphs

    Steps:
    1) From the start menu, go to programs, go to Microsoft office and click on Microsoft excel.
     
    We will be creating a bar graph based on this information.
    Tree Growth 1999
    Gala 37 cm
    Cameo 48 cm
    Red Delicious 21 cm
    Fuji 31 cm

    2) Insert you data in 2 columns. It can be any 2 columns. When entering data, do not enter in any units.
     A    B
     Gala    37
     Cameo    48
     Red Delicious  21
     Fuji    31

     
    3) Using the mouse, highlight the information you want to graph.
     
    4) Go to the insert command and then click on chart.
     
    5) Select the type of graph you would like to create. For our example, we will click on column graph. Click next.
     
    6) A graph should then be shown, click next again.
     
    7) We will now label our graph. Under chart title you will title your graph. In our case, we will title it Tree Growth in 1999. We will then label our x-axis with Type of Tree and our y-axis with Tree Growth (cm).
     
    *(If creating a circle graph, only the title label will be available. If you click on data labels more options are now available. If you choose, show label and percent, the computer will automatically convert each part to a percent and label each part)
     
    Then click next.
     
    8) The graph has now been created. You can either chose as new sheet or new object. Most of the time we will click on new sheet.
     
    *If creating a scatterplot: To add a trendline, after the graph is finished, click on one of the points. Go to chart and click on add trendline and the trendline should appear.
     
     
    Month
    Water Used
     
    April
    1,512 gals.
     
    May
    1,634 gals.
     
    June
    1,889 gals.
     
    July
    2,432 gals.
     
    August
    3,310 gals.
     
          		Sulfur Spray
    Gallons
     
    April
    100
     
    May
    30
     
    June
    100
     
    July
    20
     
    August
    0
     

     
     
    3. Create a scatterplot to show the relationship between points scored and wins for NFC football teams in 2002.
    Team
    Pts/G
    Wins
    New Orleans
    27.0
    9
    Philadelphia
    25.9
    12
    Atlanta
    25.1
    9
    Green Bay
    24.9
    12
    Minnesota
    24.4
    6
    San Francisco
    22.9
    10
    Seattle
    22.2
    7
    Tampa Bay
    21.6
    12
    New York (N)
    20.0
    10
    St. Louis
    19.8
    7
    Washington
    19.2
    7
    Detroit
    19.1
    3
    Chicago
    17.6
    4
    Arizona
    16.4
    5
    Carolina
    16.1
    7
    Dallas
    13.6
    5

    4. In the year 2000, a survey conducted by the Employment Review was conducted on the highest level of education people received. There were approximately 3,210 people in the survey. The results were as follows: 830 for high school, 490 for tech or trade school, 120 for master’s degree, 100 for doctorate degree and 1,670 for a bachelor’s degree. Create a pie graph to show the percentages of each degree.

    Back to top