Excel 2007 Line Graph Tutorial

Formatting the Line Graph - 1

Excel 2007 Line Graph

© Ted French

Formatting the Line Graph - 1

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

When you click on a graph, three tabs - the Design, Layout, and Format tabs are added to the ribbon under the title of Chart Tools.

Choosing a style for the line graph

1. Click on the line graph.
   
   
2. Click on the Design tab.
   
   
3. Choose Style 4 of the Chart Styles

Adding a title to the line graph

1. Click on the Layout tab.
   
   
2. Click on Chart Title under the Labels section.
   
   
3. Select the third option - Above Chart.
   
   
4. Type in the title "Average Precipitation (mm)"

Changing the font color of the graph title

1. Click once on Graph Title to select it.
   
   
2. Click on the Home tab on the ribbon menu.
   
   
3. Click on the down arrow of the Font Color option to open the drop down menu.
   
   
4. Choose Dark Red from under the Standard Colors section of the menu.

Changing the font color of the graph legend

1. Click once on Graph Legend to select it.
   
   
2. Repeat steps 2 - 4 above.

Changing the font color of the axis labels

1. Click once on the months labels below the horizontal X axis to select them.
   
   
2. Repeat steps 2 - 4 above.
   
   
3. Click once on numbers beside the vertical Y axis to select them.
   
   
4. Repeat steps 2 - 4 above.

• 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