1. Technology

Your suggestion is on its way!

An email with a link to:

http://video.about.com/spreadsheets/How-to-Create-a-Line-Graph-in-Excel.htm

was emailed to:

Thanks for sharing About.com with others!

Video:How to Create a Line Graph in Excel

with Nick Richards

Creating a line graph in Excel 2010 is easy, you just need to learn the basic steps! Watch this About.com video to see how it's done.See Transcript

  • All Videos
  • All Technology Videos
  • Spreadsheets Videos

Transcript:How to Create a Line Graph in Excel

Hi, I'm Nick and today for About.com, I'm going to show you how to create a line graph in Excel.

Why Use Line Graphs?

Line graphs are a great way to display data in a way that's quickly digestible and easy on the eye.

Creating Line Graphs in Excel 2010

To create a line graph, highlight the data you want to be turned into a graph and select the 'Insert' ribbon. Select the 'Line' option to gain access to a number of templates. Choose the one which matches your needs and the graph will immediately appear in your spreadsheet. You can move and resize the graph to fit your spreadsheet, if needed.

Design Options for Graphs in Excel

With the graph selected, there are a number of design choices available. In the 'Design' ribbon, you can change the basic templates of the graph from a number of preset options. To add a title to your graph, switch to the 'Layout' ribbon and select 'Chart Title'. This will place a customizable title into your graph, which you can adjust by clicking with the mouse.

Customizing a Graph in Excel

By heading to the 'Home' ribbon, you have access to further customizable options, including text color, size and the specific font you wish to use. Each element of the graph can be altered in the same way. Simply click on the specific part you wish to change to get started!

Changing the Background in Excel

To change the background color of a selected item, open the 'Format' ribbon and choose 'Shape Fill' to gain access to a host of colors and gradients. Again, each different element of the graph is customizable so make sure you go through the whole thing until you get the look you want.

Now you know how to create a line graph in Excel. For more tips and tricks, visit Compute.About.com.

About videos are made available on an "as is" basis, subject to the User Agreement.

©2014 About.com. All rights reserved.