PAF 101 Tutorial for the Graph on 5.3
If you find yourself struggling with the Graphs for Module 3, here are some easy steps for the graph on 5.3. These instructions were constructed on Microsoft 2013, so that it could be used by more students. If you have an older version of Microsoft Office such as 2007 or 2003, or if you have 2016 and are confused, please email your TA.
*This contains the same information as the video on the PAF 101 website
1)Create Table Resembling the following:
2)Insert Graph, “Line with Markers”:
3)Your graph should appear to look something like the following:
4)Using the “Add Chart Element” dropdown insert the following: Primary Horizontal Axis Title, Primary Vertical Axis Title, and Data Labels Above the points. Also, unselect Primary Major Horizontal Gridlines from the dropdown list under “Gridlines.”
5)Your Graph should now appear something like the following:
6)Double-click on your graph and enter into the “Format Chart Area”
7)Remove the Border by clicking on the “BORDER” dropdown and selecting “No line”
8)Select the Chart Area that encompasses your Time Intervals by clicking on it, i.e. where this graph has Year 1, Year 2, etc.
9)Select the “Line” dropdown, click on “Solid line” and change the color to “Black”
10)Proceed to click on the Bar Graph Icon, then enter into the “TICK MARKS” dropdown and change “Major type” to “Outside”
11)While still having the box selected, change the font to Times New Roman size 12 font and change the Font Color to Black
12)Rename the Horizontal Axis Title with the corresponding Time Period heading, such as: Years, School Years, or Academic Years. Change the font to Times New Roman size 12 font, change the Font Color to Black, and make the text BOLD
13)Return to step 12 and redo the steps for the Chart Area that encompasses your Percentage variable. Acceptable titles will vary based on the variable that is being studied, but one of the key words, “Percentage” or “Rate,” should be in the label title, but not both. While in the same menu as at the top of the page, also select the “NUMBER” drop down, change the category to “Percentage” if it is not already and change the Decimal Places to 0.
14)Your graph should look something like the following:
15)Select the line (This should cause all of the data points to be selected) and enter into the “Format Data Series” box
16)Under “Line” select the “Line” dropdown and change the line to “Solid line” then change the color to Black
17)Switch over to the “Marker” side and select the “Fill” dropdown. Change the fill to “Solid fill” and change the color to Black. Also, select the “Broder” dropdown, switch that to “Solid line” and change the color to Black
18)Your graph should appear like the following:
19)Click on the data label textboxes, go to the Bar Graph looking tab in the “Format Data Labels” box, and enter into the “Number” dropdown. Change the category to “Percentage” and then adjust the Decimal places to “1.” Change the font to Times New Roman size 12 font and change the Font Color to Black.
20)Your graph should appear something similar to the following:
21)Change the Graph Title to something that reflects your variable. Look at the Maxwell Manual for additional help with naming. Make sure to include the societal variable, the geographic location, and the timeframe. Your title should include the word “Rate” or the word “Percentage” but NOT Both. Change the font to Times New Roman size 12 font, change the Font Color to Black, and make it BOLD
22)Your graph should appear like the following: (Feel free to adjust the height and width of the graph for visibility purposes)
23)Copy and paste the graph from Excel into your Module, we suggest pasting it as an image for resizing purposes in word. This can be done by selecting the “Picture” paste option:
24)Specify the source below the graph:
Source: New York State Department of Sleep Habits