How to Make a Line Graph From Data in Microsoft Excel

PDF download Download Article
Quickly make a line graph for one or more sets of data in Excel
PDF download Download Article

If you have data to present in Microsoft Excel, you can use a line graph. This can easily be created with 2-D and 3-D Line Chart tool. You'll just need an existing set of data in a spreadsheet. Then, you can make a customizable line graph with one or multiple lines. This wikiHow will show you how to create a line graph from data in Microsoft Excel using your Windows or Mac computer.

Things You Should Know

  • Highlight the data you want in the graph by clicking the top-left cell and dragging to the bottom-right cell.
  • Click "Insert" → "Line Graph" icon (two intersecting line graphs) → click a graph style.
  • Click the graph to customize it. Change the style, position, size, and name of the graph.
Part 1
Part 1 of 2:

Creating a Graph

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-6.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-6.jpg","bigUrl":"\/images\/thumb\/5\/59\/Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-6.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-1-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can use an existing project or create a new spreadsheet . [1]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-6.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-6.jpg","bigUrl":"\/images\/thumb\/5\/50\/Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-6.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-2-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click and drag over the cells containing the data you want to use in your line graph. If your data isn't already entered, do so now. Be sure to select column headers if you have them.
    • To select everything, click the top-left cell of the data. Press CTRL + A (Windows) or Command + A (Mac).
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-6.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-6.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-6.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-3-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is at the top toolbar.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg","bigUrl":"\/images\/thumb\/1\/16\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-5.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This looks like two intersecting line graphs. You can find this in the Charts section.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-5.jpg","bigUrl":"\/images\/thumb\/8\/89\/Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-5.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-5-Version-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Hover the mouse cursor over a line graph template in the drop-down menu to see what it will look like with your data.
    • The first section of graphs has traditional two-dimensional line graphs, while the second has one or more 3D line graphs.
    • If you have a lot of data, the preview may take a moment to appear.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-6.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-6.jpg","bigUrl":"\/images\/thumb\/9\/9d\/Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-6.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-6-Version-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Once you decide on a line graph template, clicking it will create your graph in the middle of the Excel window.
    7. Advertisement
Part 2
Part 2 of 2:

Customizing the Graph

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-9-Version-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Once you create your graph, the Chart Design toolbar will open. You can select one of the styles in the toolbar to quickly select a new look for your line chart.
    • If this toolbar doesn't open, click your line graph and then click the Design tab in the green ribbon.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click and drag the white space near the top of the line graph to move it.
    • You can also move specific sections of the line graph (e.g., the title) by clicking and dragging them around within the line graph's window.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/97\/Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/97\/Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click and drag one of the circles on one of the edges or corners of the graph window in or out to shrink or enlarge your graph.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-460px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/39\/Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-728px-Make-a-Line-Graph-in-Microsoft-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Double-click the title of the graph, then select the "Chart Title" text and type in your graph's name. Clicking anywhere off of the graph's name box will save the text.
    • If you want to label your graph's axes , click the graph.
      • Click + at the right side of the graph. A pop-up menu will open.
      • Check the box for Axis Titles .
      • Double-click the Axis Title box and delete the default text.
      • Enter a new title.
    5. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I name the y and X axis in the graph?
    Community Answer
    1. Click on the graph. 2. Select 'Chart Elements' on the side, which is the plus icon. 3. Tick the 'Axis Titles' box. Some text boxes should appear on the x and y axis.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 47 Helpful 33
  • Question
    If multiple lines are present in my chart, how can I view one at a time?
    Community Answer
    One method is to hide the relevant rows or columns that you do not wish to show on the graph. Hidden rows and columns are not displayed.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 37 Helpful 21
  • Question
    Why do my years show up as numbers?
    Community Answer
    Because A,B,C,D,E, and F, mean this: (A:2000->B:2001->C:2002->D:2003->E:2004->F:2005.)
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 104 Helpful 38
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • You can add data to your graph by entering it in a new column, selecting and copying it, and then pasting it into the graph window.
        Thanks


      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to Make a Graph in Microsoft Word
      How to
      Truncate Text in Excel
      5 Easy Steps to Unmerge Cells in Microsoft Excel
      3 Simple Ways to Edit Data in MS Excel
      How to Create a Graph in Excel
      How to
      Find the Y Intercept
      How to Find Horizontal Asymptotes: Rules for Rational Functions
      How to
      Read a Psychrometric Chart
      How to
      Graph Sine and Cosine Functions
      How to
      Create a Graph in Google Sheets
      2 Easy Ways to Make a Chart with Two Y Axes in Excel
      How to
      Graph a Parabola
      How to
      Graph an Equation
      How to
      Make a Bar Graph in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/topic/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e

      About This Article

      Article Summary X

      1. Open a new Excel document.
      2. Enter your graph's data.
      3. Select the data.
      4. Click the green Insert tab.
      5. Click the "Line Graph" icon .
      6. Click a line graph template.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,542,405 times.

      Is this article up to date?

      Advertisement