How do I plot multiple data sets with different x and y values on one graph?
Solution 1:
If you want your plot to have data from both sets you can achieve it by
- Select the plot
- Goto "Design" tab and "Select Data"
- "Add" the new series and select data points in new series
And it will look like
But if you are worried about the spread of data in set 1 and set 2, and difficulty in pattern understanding, you can switch x & y and you can use secondary axis. This plot will look like
Hope you wanted either of this.