Excel Line Graph Tutorial

By Ted French, About.com Guide

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

Previous

• Create a Line Graph in Excel
• 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

Next