• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Line Chart Excel

April 8, 2021 by Andrew Childress
Add line graph to Excel

A line graph is a handy way to illustrate data. But why draw them by hand when you have spreadsheets. Here's how to make a line graph in Microsoft Excel.

A line graph is a handy way to illustrate data. But there’s no need to draw them by hand when you have spreadsheets. Let’s learn how to make a line graph in Microsoft Excel.

How to Make a Line graph in Excel

Let’s say you have a table of data showing annual sales for a few previous years. It might be helpful to display this in graph form to make it easier to understand.

Excel makes it easy to add a line graph. To begin, go ahead and select all the cells in the table. In this case, the range is A1:B5. This will tell Excel exactly what to include in the graph.

Then, go to Excel’s Insert tab on the ribbon. Near the center, you’ll see the graphs group. Here, there are many options for different kinds of graphs. In this case, you want a line graph, so click on the Line dropdown arrow.

Line graph Excel

You’ll see an array of styles and options appear on a dropdown menu. Excel offers both 2D and 3D styles to show off data in different ways. In many cases, simple is best, so click on the first option in the upper left: 2-D Line > Line.

Excel line graph

Instantly, a basic line graph will be inserted onto your spreadsheet. You can click and drag it to move it around the sheet, and the corners can be dragged to resize it. On the graph Design menu on the ribbon, notice several options. You can add things like axis titles, or change the color of the line.

Add line graph to Excel

There are background options, and different styles that you can apply. It’s also possible to change the graph title. Simply click into the text box in the graph, and type in something new.

Excel makes it easy to add and customize line graphs.

Category: Excel Tutorials

About Andrew Childress

Previous Post:Calculate variance in ExcelCalculate Variance Excel
Next Post:Standard Deviation in ExcelStandard deviation in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top