0.16 Creating a line graph  (Page 2/2)

• * Click on the actual “chart”
• * OK

Two screens will “pop” up. A chart with graphs and an excel spreadsheet

***** Make sure to continue to SAVE your work

Step two

Using the excel spreadsheet, create the categories and series, depending upon your information.

• * You can use your SPSS output data (mean scores) to input data
• * For example, if you have a table with the following information:

• √ Decide which variables will be the categories and series (the categories will be the title that appears under the graphs&the series will be the key).
• √ Begin filling in your columns and rows in the excel file.
• √ The first column will be, using the table information above, will contain the years.
• √ The second column will be Very Small Schools, the first grouping cited in the table above.
• √ This is handled by highlighting each cell and typing the information within the cell, as shown in figure below
• * The illustration below demonstrates step by step how you can fill your columns/rows
• * The first row would be filled (using the table 3 information above) with the very small schools first
• * The graph to the right will instantly appear as you type in the numbers in the row (see arrows)

• * Next, insert column “C” with the title “Small School” and insert data (as illustrated in table 3):
• * The graph to the right will instantly appear as you type in the numbers in the row (see arrows)

• * Next, insert column “D” with the title “Large School” and insert data (as illustrated in table 3):
• * The graph to the right will instantly appear as you type in the numbers in the row (see arrows)

• √ You can also make your cells larger or smaller by placing your mouse between the cells until you are able to move the lines over:

• √ You can switch back and forth from the excel spreadsheet to the chart, using the tabs on the bottom of your excel sheet
• * To replace “Category 1, Category 2, Category 3, Category 4”, simply highlight cells in column A with the information pertaining to your research

After inputting your information, your chart will resemble the following:

Step three:

If you decide to change the color of your line graph:

• * You must be at your chart and click on the actual graph (this will make Chart Tools appear above in the option area)
• √ Go to Chart Tools
• * Design
• * "Chart styles
• * Change Chart Type
• * Click the down arrow, which will give you many options
• * Highlight a chart style

If you decide to change your graph line layout :

• √ Chart Tools
• * Go to tab designated "Design"
• * Chart layouts (not to be confused with tab titled "Layout")
• * Click the down arrow, which will give you many options

If you decide to change your de sign to a different chart:

• √ Chart Tools
• * Design
• * Go to Change Chart Type (furthest left hand icon)

• * Choose a different design (your data will transfer to another design)
• * You can scroll down to choose a different design
• * Click on design
• * Click on OK
• * You can now change color, arrangement of bubbles, using the same steps as mentioned above

If you decide to insert a title at the top of the figure:

• √ Chart Tools
• * Design

• * Go to Change Chart Layouts (not to be confused with tab titled “Layout”)

• * Click the down arrow until you see the graph with the “Title”
• * This will give you many different options for titles and graph layouts

• * Click on to Graph section titled Chart Title to enter your new title.

• *Enter the title of your line graph

In APA 6th edition style, you will need to type Figure 1. (if the first figure) and a longer title for the figure immediately below the graph.