0

How can I plot this set of data on Excel or OriginLab, possibly scatter plot, where a same x value corresponds to multiple y

x, y

1, 1

1, 2

1, 3

2, 2

2, 3

2, 4

I actually have hundreds of x values, each with 20 different y values.

I found the reason. We need to make sure the number is on the right of the cell, not on the left. enter image description here

enter image description here

Improve this question

1 Answer 1

Reset to default
1

This can be done quite easily using Excel. First arrange your data like this:

enter image description here

Select all your data by holding and dragging the mouse over the cells containing the data as shown in the above picture. Now go to Insert>Scatter:

enter image description here

(choose the type of scatter graph you want)

That's it. You will have your graph right on the table. See this:

enter image description here

(You can change axis name, scale and much more as per your requirements by going to Chart Tools)

I hope that this helped :)

Improve this answer
2
  • Okay. You've done it now. If the answer deserve an upvote, please consider :)
    – user871532
    May 3, 2020 at 2:56
  • 1
    Thank you for the help. Actually, it is the format that makes the difference. I updated in my question.
    – lanselibai
    May 3, 2020 at 3:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .