+ Reply to Thread
Results 1 to 2 of 2

Creating line graph with two lines.

  1. #1
    Registered User
    Join Date
    09-13-2016
    Location
    London
    MS-Off Ver
    Ms office 2015
    Posts
    1

    Creating line graph with two lines.

    Hello, I'm trying to create a line graph with two lines but I'm having quite a bit of trouble. I can create a line graph with all my data but I just can't figure out how to format it correctly. I want the dates to be on the X-axis and the rates on the vertical with two lines one representing the 1 year rate and one representing the 10 year rate. Whenever I try and select the data I get all of these series and I just can't make out how to format this correctly. Any and all guidance would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Creating line graph with two lines.

    You did not include any of your failed attempts at creating a chart in your file, so it is difficult to see what you have done wrong.

    If I were creating such a chart from this data:

    1) Select columns A and B.
    2) Insert the chart (I don't know if you are wanting a line or an XY scatter chart -- either seems like it would work).
    3) If needed (because Excel often misinterprets what I wanted at chart creation), go into the "Select Data" dialog and remove, edit, add data series as needed.
    4) Then add the second data series (also using the Select Data dialog).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  2. line graph help - multiple lines
    By chsl2008 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-24-2011, 06:58 AM
  3. Plotting 2 lines on a line graph
    By andrewsco in forum Excel General
    Replies: 2
    Last Post: 09-10-2010, 09:27 AM
  4. How do i get lines on a line graph?
    By baffledbrewer in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2006, 08:38 AM
  5. How do i get lines on a line graph?
    By baffledbrewer in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2006, 08:31 AM
  6. Line Graph with 2 lines
    By Need help making line graph with 2 lines in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-19-2006, 03:50 PM
  7. I can't get the lines to connect on my line graph
    By solesmate in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2005, 06:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1