0

I have 2 sets of data in tabular form, say (x,y) and (x,z). Both sets share variable x, but for each set x has a different increment (see example). I would like to generate a graph (y,z) without using VBA or third party interpolation apps. Thank you in advance for your responses.

Example:

Dataset 1:

x: 1, 2, 3

y: 1, 2, 7

Dataset 2:

x: 0.3, 0.6, 0.9, 1.2, 1.5, 1.8, 2.1, 2.4, 2.7, 3.0

z: 1,   2,   3,   4,   5,   6,   7,   8,   9,   10
Improve this question
1
  • Just to clarify, are you looking to graph Y and Z in relation to X, as described in Máté Juhász's answer, or Y vs. Z (without X, where one would become the X and the other the Y for graphing purposes)?
    – fixer1234
    Sep 5 '16 at 17:02
1

You can easily do it with scatter plot:

  • Select your first dataset (both x and y values)
  • navigate to insert - charts - XY (Scatter)
    (this can be slightly different depending on your Excel version)
  • insert the chart
  • right click on the chart - select data - add new series
    • here select data for horizontal and vertical axis from the second dataset

enter image description here

Improve this answer
1
  • +1 for figuring out what the question was asking.
    – fixer1234
    Sep 5 '16 at 16:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.