How to Add Additional Sets of Data to an Excel Graph

PDF download Download Article
A simple guide on adding a second set of data to your chart
PDF download Download Article

Need to visualize more than one set of data on a single Excel graph or chart? This wikiHow article will show you the easiest ways to add new data to an existing bar or line graph, plus how to plot a second data set to compare two sets of similar linear data on a single graph.

How to Add Data on Excel Graph

Right-click the chart you’d like edit and choose “Select Data.” Click the “Add” button on the Select Data Source window and enter a name for the series of data you’d like to include. Alternatively, you can click and drag the cells you’d like to include in the Select data Source window.

Method 1
Method 1 of 3:

Comparing Two Sets of Data on One Graph

PDF download Download Article
  1. Use this method if you want to compare two sets of similar data on the same graph. For example, comparing sales for red t-shirts versus blue t-shirts in the same year. [1]
  2. If you haven't already done so, add the second set of data you want to compare to the first set somewhere on the same sheet as your existing data. The cells do not have to be adjacent.
    Advertisement
  3. This opens the Select Data Source dialog window. [2]
    • You can also click the graph once, select the Chart Design tab at the top, and then click Select Data on the toolbar at the top of Word.
  4. You'll see it under the "Legend Entries (Series)" header.
  5. This is how your data will appear on the graph and legend.
    • You can also click a cell that contains the name you want to use for this range to make that cell's value the name of the series. [3]
  6. This activates the field.
  7. Once you lift your finger from the mouse, the range will appear in the "Series X values" field.
    • For example, if a set of dates runs along the X axis of your original data, select the second set of dates for this X axis.
  8. This activates the Y axis field.
  9. Use the mouse to highlight the new data you want to add to this second Y axis.
    • If you see an error when trying to select a set of data, delete everything in the field and select that range again.
  10. Now you'll see two different sets of data under "Legend Entries (Series)".
  11. Your graph now displays a comparison of two sets of data on the same chart.
    12. Advertisement
Method 2
Method 2 of 3:

Adding More Data to a Graph on the Same Sheet

PDF download Download Article
  1. Use this method if your graph and its existing data are on the same worksheet. [4]
    • This method will combine the second set of data with the original data on the existing axes.
  2. When you click the graph, you'll see lines and sizing handles surrounding the data that's already included. The second series of data you've added is not yet highlighted.
  3. For example, if you added a new column of data to the right of the existing data, drag the rightmost handle to the right to include that column in the data selection range. The chart will update right away to reflect all of the data selected. [5]
    4. Advertisement
Method 3
Method 3 of 3:

Adding More Data to Graph on a Different Sheet

PDF download Download Article
  1. Use this method if your graph and data are on separate sheets. [6]
    • This method will combine the second set of data with the original data on the existing axes.
  2. Type the new data for your graph into the cells directly next to or below your current data. [7]
  3. This opens the Select Data Source dialog window. [8]
    • You can also click the graph once, select the Chart Design tab at the top, and then click Select Data on the toolbar at the top of Word.
  4. Leaving the Select Data Source window open, use the mouse to highlight all of the data you want to include in your chart, including the existing data. [9]
    • Once you select some data, the series will appear under "Legend Entries (Series)" on the left side of the Select Data Source window.
  5. This closes the dialog window and adds the second data set to your chart.
    6. 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

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      Advertisement

      References

      1. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      2. ↑ https://support.microsoft.com/en-au/office/change-the-data-series-in-a-chart-30b55a30-1c2e-42d5-8ed1-3cc3ffb68036
      3. ↑ https://www.youtube.com/watch?v=u7V1LPVlHck
      4. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      5. ↑ https://support.microsoft.com/en-gb/office/move-or-resize-a-chart-f9d6087b-1d7b-4a72-8d81-1d0788ea783f
      6. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      7. ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12
      8. ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12
      9. ↑ https://support.microsoft.com/en-us/office/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12

      About This Article

      Article Summary X

      1. Right-click the graph and select Select Data .
      2. Click Add .
      3. Type a name for the range.
      4. Click the "Series X values" field and then select data for the X axis.
      5. Click the "Series Y values" field and select data for the Y axis.
      6. Click OK and then OK again.

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

      Is this article up to date?

      Advertisement