Excel 2007 Line Graph Tutorial

Selecting a Line Graph Type

Excel 2007 Line Graph

© Ted French

Selecting a Line Graph Type

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

1. Click on the Insert ribbon tab.
   
   
2. Click on a chart category to open the drop down list of available graph types
   
   (Hovering your mouse pointer over a graph type will bring up a description of the graph).
   
   
3. Click on a graph type to select it.

For this tutorial

1. Choose Insert > Line > Line with Markers.
   
   
2. A basic line graph is created and placed on your worksheet. The following pages cover formatting this graph to match the line graph shown in Step 1 of this tutorial.

• 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