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. You can use an existing project or create a new spreadsheet . [1]
  2. 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. This is at the top toolbar.
  4. This looks like two intersecting line graphs. You can find this in the Charts section.
  5. 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. 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. 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. 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. 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. 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.
  • 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.
  • 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.)
See more answers
Ask a Question
      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.


      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      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?
      Thanks to all authors for creating a page that has been read 1,556,106 times.

      Is this article up to date?

      Advertisement