Excel Line Graph Tutorial

By Ted French, About.com Guide

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

. Return to the format options list

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)"

. Return to the format options list

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.

. Return to the format options list

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