1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Line Graph Tutorial

By , About.com Guide

2 of 8

Entering the Graph Data

Excel 2007 Line Graph

Excel 2007 Line Graph

© Ted French

Enter the Graph Data

Note: For help with these instructions, see the image example above.

No matter what type of chart or graph you are creating, the first step in creating an Excel chart is always to enter the data into the worksheet.

When entering the data, keep these rules in mind:

  1. Don't leave blank rows or columns when entering your data.

  2. Enter your data in columns.
    • When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.

    • If there is more than one data series, list them one after the other in columns with the title for each data series at the top.

For this tutorial

  1. enter the data located in step 8.
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Lesson Plans
  5. Line Graph - Excel Line Graph - Make a Line Graph in Excel 2007

©2009 About.com, a part of The New York Times Company.

All rights reserved.