EXCEL SKILLS: LINE/SCATTER GRAPHS, ROWS AND COLUMNS, INDEX, MATCH Line and Scatter Graphs Line Graphs Scatter Graphs Show change over time Show paired numerical data Show change in continuous variables Show correlation between variables X-axis have numerical value (year, X-axis has numerical value ID number How to Make a Line Graph Source: IPEDS: National Center for Education Statistics To start, you should have two sets of data, one for the X-axis and Y-axis Go to the tab and select the line option. Select one set of data for “Charts” your X-axis and one for the Y-axis. You can either type the cells in or copy and paste them. To write a title, legend, and labels for the axes, click the Layout” tab, “Chart select Format, and select each element that want to create. How to Make a Scatter Graph You should have your data ready to be able to insert the graph. Go to the tab and select the scatter option. Select one set of data for “Charts” the X-axis. To write a title, legend, and labels for the axes. Click the Layout” tab, “Chart select Format, and select each element that want to create. To edit later, you can right click the graph and click Data” which brings you to “Select this menu.
EXCEL SKILLS: LINE/SCATTER GRAPHS, ROWS AND COLUMNS, INDEX, MATCH Line and Scatter Graphs Line Graphs Scatter Graphs Show change over time Show paired numerical data Show change in continuous variables Show correlation between variables X-axis have numerical value (year, ID number X-axis has numerical value How to Make a Line Graph Source: IPEDS: National Center for Education Statistics To start, you should have two sets of data, one for the X-axis and Y-axis Go to the “Charts” tab and select the line option. Select one set of data for your X-axis and one for the Y-axis. You can either type the cells in or copy and paste them. To write a title, legend, and labels for the axes, click the “Chart Layout” tab, select Format, and select each element that want to create. How to Make a Scatter Graph You should have your data ready to be able to insert the graph. Go to the “Charts” tab and select the scatter option. Select one set of data for the X-axis. To write a title, legend, and labels for the axes. Click the “Chart Layout” tab, select Format, and select each element that want to create. To edit later, you can right click the graph and click “Select Data” which brings you to this menu.
SOM307_STUDYGUIDE.docx