Excel 2007 Line Graph Tutorial

Select the Line Graph Data

Excel 2007 Line Graph

© Ted French

Two Options for Selecting the Graph Data

Using the mouse

1. Drag select with the mouse button to highlight the cells containing the data to be included in the line graph.

Using the keyboard

1. Click on the top left of the line graph's data.
2. Hold down the SHIFT key on the keyboard.
3. Use the arrow keys on the keyboard to select the data to be included in the line graph.

Note: Be sure to select any column and row titles that you want included in the graph.

For this tutorial

1. Highlight the block of cells from A2 to C6, which includes the column titles and the row headings

• Create a Line Graph in Excel 2007
• Entering the Graph Data
• Select the Line Graph Data
• Selecting a Line Graph Type
• The Basic Line Graph
• Formatting the Line Graph - 1
• Formatting the Line Graph - 2
• Line Graph Tutorial Data