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