Skip to content Skip to navigation

Connexions

You are here: Home » Content » Creating a Line Graph

Navigation

Lenses

What is a lens?

Definition of a lens

Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

Who can create a lens?

Any individual member, a community, or a respected organization.

What are tags? tag icon

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

This content is ...

Endorsed by Endorsed (What does "Endorsed by" mean?)

This content has been endorsed by the organizations listed. Click each link for a list of all content endorsed by the organization.
  • NCPEA

    This module is included inLens: National Council of Professors of Educational Administration
    By: National Council of Professors of Educational AdministrationAs a part of collections: "Making Microsoft Word User-Friendly for Dissertations, Theses, and Manuscripts: Part II", "Making Microsoft Word User-Friendly for Dissertations, Theses, and Manuscripts"

    Click the "NCPEA" link to see all content they endorse.

Recently Viewed

This feature requires Javascript to be enabled.
 

Creating a Line Graph

Module by: John R. Slate, Ana Rojas-LeBouef. E-mail the authors

ncpealogo.gif

Note:

This chapter is published by NCPEA Press and is presented as an NCPEA/Connexions publication as a "print on demand book." Each chapter has been peer-reviewed, accepted, and endorsed by the National Council of Professors of Educational Administration (NCPEA) as a significant contribution to the scholarship and practice of education administration.

About the Authors

  • John R. Slate is a Professor at Sam Houston State University where he teaches Basic and Advanced Statistics courses, as well as professional writing, to doctoral students in Educational Leadership and Counseling. His research interests lie in the use of educational databases, both state and national, to reform school practices. To date, he has chaired and/or served over 100 doctoral student dissertation committees. Recently, Dr. Slate created a website (Writing and Statistical Help) to assist students and faculty with both statistical assistance and in editing/writing their dissertations/theses and manuscripts.
  • Ana Rojas-LeBouef is a Literacy Specialist at the Reading Center at Sam Houston State University where she teaches developmental reading courses. Dr. LeBoeuf recently completed her doctoral degree in Reading, where she conducted a 16-year analysis of Texas statewide data regarding the achievement gap. Her research interests lie in examining the inequities in achievement among ethnic groups. Dr. Rojas-LeBouef also assists students and faculty in their writing and statistical needs on the Writing and Statistical Help website.

About the Editors

  • Theodore B. Creighton, is a Professor at Virginia Tech and the Publications Director for NCPEA Publications, the Founding Editor of Education Leadership Review, and the Senior Editor of the NCPEA Connexions Project.
  • Brad E. Bizzell, is a recent graduate of the Virginia Tech Doctoral Program in Educational Leadership and Policy Studies, and is a School Improvement Coordinator for the Virginia Tech Training and Technical Assistance Center. In addition, Dr. Bizzell serves as an Assistant Editor of the NCPEA Connexions Project in charge of technical formatting and design.
  • Janet Tareilo, is a Professor at Stephen F. Austin State University and serves as the Assistant Director of NCPEA Publications. Dr. Tareilo also serves as an Assistant Editor of the NCPEA Connexions Project and as a editor and reviewer for several national and international journals in educational leadership.

In this set of steps and screenshots, readers are provided with directions on generating a line graph for statistics already calculated. We encourage readers to use visual depictions such as line graphs because of their ability to communicate statistics in a user-friendly and understandable manner.

Step One

First open a word document (Microsoft Word or other)

  • √ Insert
  • * Chart

14.1.png

  • * You will be prompted to choose the type of chart you would like to create (e.g., bar, pie, line, area, or surface) that illustrates your statistical output.
  • * Scroll down to see all options, however in this chapter, we will create a line graph.

14.2.png

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

14.3.png

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

14.4.png

***** 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:
Table 1: Descriptive Statistics for Hispanic Students TAKS Mathematics Passing Rates by Year
School Size M
Very Small Schools  
2003–2004 77.60
2004–2005 76.41
2005–2006 79.02
2006–2007 83.00
2007–2008 83.13
Small Schools  
2003–2004 81.71
2004–2005 79.30
2005–2006 81.94
2006–2007 84.26
2007–2008 85.22
Large Schools  
2003–2004 84.71
2004–2005 81.27
2005–2006 83.34
2006–2007 85.80
2007–2008 86.53
  • √ 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)

14.5.png

  • * 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)

14.6.png

  • * 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)

14.7.png

  • √ 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:

14.8.png

  • √ 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:

14.9.png

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

14.10.png

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

14.11.png

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

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

14.12.png

  • * 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

14.13.png

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

  • √ Chart Tools
  • * Design

14.14.png

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

14.15.png

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

14.16.png

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

14.17.png

  • *Enter the title of your line graph

14.18.png

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.

Content actions

Download module as:

PDF | EPUB (?)

What is an EPUB file?

EPUB is an electronic book format that can be read on a variety of mobile devices.

Downloading to a reading device

For detailed instructions on how to download this content's EPUB to your specific device, click the "(?)" link.

| More downloads ...

Add module to:

My Favorites (?)

'My Favorites' is a special kind of lens which you can use to bookmark modules and collections. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need an account to use 'My Favorites'.

| A lens I own (?)

Definition of a lens

Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

Who can create a lens?

Any individual member, a community, or a respected organization.

What are tags? tag icon

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks