1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 Line Graph Tutorial

By , About.com Guide

7 of 8

Formatting the Line Graph - 2

Excel 2007 Line Graph

Excel 2007 Line Graph

© Ted French

Formatting the Line Graph - 2

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

Coloring the graph background

  1. Click on the graph background.

  2. Click on the Shape Fill option to open the drop down menu.

  3. Choose Red, Accent 2, Lighter 80 % from the Theme Colors section of the menu.
Return to the format options list

Coloring the plot area background

  1. Click on one of the horizontal grid lines to select the plot area of the graph.

  2. Choose theShape Fill > Gradient > From Center option from the menu.
Return to the format options list

Beveling the graph edge

  1. Click on the graph to select it.

  2. Click on the Shape Fill option to open the drop down menu.

  3. Choose Bevel > Cross from the menu.

At this point, your graph should match the line graph shown in Step 1 of this tutorial.

Return to the format options list

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Lesson Plans
  5. Line Graph - Excel Line Graph - Make a Line Graph in Excel 2007

©2009 About.com, a part of The New York Times Company.

All rights reserved.