How to Graph Multiple Lines in Excel

PDF download Download Article
Plot multiple lines on one chart with this easy tutorial
PDF download Download Article

It's easy to graph multiple lines using Excel! If your spreadsheet tracks multiple categories of data over time, you can visualize all the data at once by graphing multiple lines on the same chart. You can either create a graph from scratch or add lines to an existing graph. This wikiHow article will teach you how to graph multiple lines.

Quick Steps

  1. Arrange your data in columns for each line to plot.
  2. Select the data you want to graph.
  3. Click the Insert tab.
  4. Select the line graph from "Recommended Charts."
  5. Click OK .
Method 1
Method 1 of 3:

Setting Up an Excel Spreadsheet

PDF download Download Article
  1. Enter Excel by either opening the application downloaded to your device or on an internet browser through your Microsoft Office 365 account. If you do not have the Excel app or a Microsoft 365 subscription, you can buy it or start a free trial on the Microsoft website at https://www.microsoft.com/en-us/microsoft-365/excel .
    • Excel is available on Windows, Mac, and Android devices. You can use Excel on a computer, tablet, or phone.
    • A subscription to Microsoft 365 will give you access to Excel, Word, Powerpoint, and many other Microsoft applications. This subscription costs $69.99/year for an individual plan, and $99.99/year for the family plan. The family plan can be shared with up to 6 people. [1]
  2. On your Excel home screen, click "New blank workbook". This action will open an empty spreadsheet where you can begin to enter your data.
    • If you have already started working on a spreadsheet which you would like to use for your graph, you can open that workbook from the Excel homepage under either the "All" or "My recent" categories.
    • Directly next to the "New blank workbook" option, you will see "Welcome to Excel". If you are new to Excel, consider clicking this option to learn the basics of using this application.
    Advertisement
  3. Plotting a line requires data for two different axes. On a line graph, these axes measure change in data over time. For example, if you were measuring distance over time, the x-axis would be time and the y-axis would be distance. Let the leftmost column, column A, represent time, your x-axis. Enter the points in time you want your x-axis to cover in column A. In the next column over, enter the data points for the first line you wish to plot over the time period in column A. Add the data for your next line in the next column over, and repeat this process until all of the data points you want to graph are listed under a column on the spreadsheet. These columns will all appear as lines plotted over time, the x-axis of your graph. [2]
    • All of the data points for the same line need to be listed in the same column.
    • Label your data categories in row 1. For column A, this label will be the metric of time you will graph your lines over. Label your other columns with the category of data they represent.
    • For example, if you were graphing the sales of different Honda models over the past decade, column A would be labeled "Year" and columns B, C, and D could be labeled "CR-V", "Civic", "Accord", and so on. Your lines would then be labeled as CR-V, Civic, and Accord, and plotted over the years you entered in column A.
    4. Advertisement
Method 2
Method 2 of 3:

Using Your Spreadsheet Data to Graph Multiple Lines

PDF download Download Article
  1. Click and drag your mouse over the columns of data you wish to graph. Drag your mouse from the top left corner to the bottom right corner of the data set you want to appear in your graph. The data you have selected will be highlighted in the spreadsheet. [3]
    • Each column of data you select will be plotted as a different line on your graph.
    • Be sure to include the column headers in your selected data group. These categories will be shown on the legend of your line graph.
  2. Above the spreadsheet, you will see a menu of editing options for your spreadsheet. Find and click on the "Insert" option in this menu. [4]
  3. Below the menu where you selected "Insert", you should see a new menu which will include a section of "Recommended Charts". In this section, select the line graph icon to insert a line graph of your data into the spreadsheet. Inserting a line graph will automatically generate a graph of lines representing your data points. Each of your data columns will appear as a separate line on the graph. [5]
    • If you wish to create a line graph with just one line, select only one column of data before inserting your graph.
    • Graphing multiple lines on the same chart is a great way to visually compare data sets.
    • If you labeled each of your data categories in row 1, these labels will appear in a legend at the bottom of your graph, showing which color line symbolizes which group of data.
    4. Advertisement
Method 3
Method 3 of 3:

Adding a Line to an Existing Graph

PDF download Download Article
  1. Add your data into the column directly to the right of the last data column included in your graph. [6]
    • Be sure to title this column in row 1 so that it is labeled on the graph.
    • You can create a new graph including this data by repeating the steps of highlighting a data set and inserting a line graph. If you would rather add a new line to an existing graph, follow the steps below.
  2. Click once on the line graph in your spreadsheet to select it. Then navigate to the "Chart" section in the menu at the top right corner of your spreadsheet. [7]
    • In this menu, you can edit many components of your graph such as the title and style of your line graph.
  3. Opening the "Chart" section will drop down a menu of more specific options related to your graph. Choosing the "Select Data" option will pull up a window representing which range of data is represented by your line graph.
  4. In the "Select Data" window, you should see a data range. Say, for example, your data range covers from column A, row 1, to column E, row 6 on the spreadsheet. This data range would appear as "=Sheet1!$A$1:$E$6". Add new data to this range by changing the second letter value of the range to the letter of the furthest right column you are adding plotting on your graph. Updating a graph's range of data will automatically plot that data on the graph.
    • If you had graphed lines for columns A through E, and wanted to make lines for data in columns F and G, you would change the second letter in the range to "G".
    • If you are adding a new row of data, change the second number value to include the new number row you want to graph.
    • Update your data range to include as many new columns of data as you want. Each column of data you add to the range will be plotted as a separate line.
    5. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

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

      You Might Also Like

      4 Easy Ways to Add the Time and Date Automatically in Sheets
      How to
      Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Copy the Same Text to Multiple Cells in Excel: Desktop & Mobile
      The 3 Easiest Ways to Sort by Number in Google Sheets
      How to
      Add Custom Calculated Fields to Pivot Tables in Excel
      How to
      Add Rows to a Pivot Table
      3 Easy Ways to Get Rid of Dotted Lines in Microsoft Excel
      Easily Embed Documents and Files in an Excel Spreadsheet
      How to
      Change the X Axis Scale in an Excel Chart
      How to
      Make a Google Spreadsheet: Beginners Guide
      How to
      Add Two Cells Containing the Sum of Other Formulas in Excel
      How to
      Add a Row to a Table in Excel
      3 Simple Ways to Create a Shared Spreadsheet
      Advertisement

      References

      1. ↑ https://www.windowscentral.com/office-2019-or-office-365-which-one-you-should-get
      2. ↑ https://spreadsheeto.com/line-graph/
      3. ↑ https://support.microsoft.com/en-us/office/create-a-chart-with-recommended-charts-cd131b77-79c7-4537-a438-8db20cea84c0
      4. ↑ https://support.microsoft.com/en-us/office/create-a-chart-with-recommended-charts-cd131b77-79c7-4537-a438-8db20cea84c0
      5. ↑ https://support.microsoft.com/en-us/office/create-a-chart-with-recommended-charts-cd131b77-79c7-4537-a438-8db20cea84c0
      6. ↑ https://support.microsoft.com/en-us/office/select-data-for-a-chart-5fca57b7-8c52-4e09-979a-631085113862
      7. ↑ https://support.microsoft.com/en-us/office/select-data-for-a-chart-5fca57b7-8c52-4e09-979a-631085113862

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 53,058 times.

      Is this article up to date?

      Advertisement