+ Reply to Thread
Results 1 to 2 of 2

Plot 2 data lines, same graph, same axis

  1. #1
    Registered User
    Join Date
    03-23-2010
    Location
    new Zealand
    MS-Off Ver
    Excel 2007
    Posts
    1

    Plot 2 data lines, same graph, same axis

    Hey

    I have 2 sets of similar data, both with the same range of values over x and y, that i would like to plot on the smae graph, each with 1 line connecting all data points.

    My data looks similar to the following-

    x1 y1 x2 y2
    23 543 19 490
    24 432 23 487
    45 456 50 520
    32 497 41 510

    Thanks for any advice

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,472

    Re: Plot 2 data lines, same graph, same axis

    Select A2:B5 and insert a xy-scatter chart
    Copy C2:D5 and then select the chart and Paste Special.

    Insert new series with x values in first column
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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